The following two tables show the API types recognized by the Microsoft® Repository engine, as well as the SQL types. These values appear in the APIType and SQLType properties of a PropertyDef object. For information on conversion between SQL and API types, please refer to the ODBC Programmer's Reference.
API TYPES
API TYPE | VALUE |
SQL_C_UTINYINT | -28 |
SQL_C_STINYINT | -26 |
SQL_C_ULONG | -18 |
SQL_C_USHORT | -17 |
SQL_C_SLONG | -16 |
SQL_C_SSHORT | -15 |
SQL_C_BINARY | -2 |
SQL_C_TINYINT | -6 |
SQL_C_BIT | -7 |
SQL_C_CHAR | 1 |
SQL_C_LONG | 4 |
SQL_C_SHORT | 5 |
SQL_C_FLOAT | 7 |
SQL_C_DOUBLE | 8 |
SQL_C_DATE | 9 |
SQL_C_TIME | 10 |
SQL_C_TIMESTAMP | 11 |
SQL TYPES
SQL TYPE | VALUE |
SQL_LONGVARCHAR | -1 |
SQL_BINARY | -2 |
SQL_VARBINARY | -3 |
SQL_LONGVARBINARY | -4 |
SQL_BIGINT | -5 |
SQL_TINYINT | -6 |
SQL_BIT | -7 |
SQL_CHAR | 1 |
SQL_NUMERIC | 2 |
SQL_DECIMAL | 3 |
SQL_INTEGER | 4 |
SQL_SMALLINT | 5 |
SQL_FLOAT | 6 |
SQL_REAL | 7 |
SQL_DOUBLE | 8 |
SQL_DATE | 9 |
SQL_TIME | 10 |
SQL_TIMESTAMP | 11 |
SQL_VARCHAR | 12 |