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 |