SQL and API Types Used in Property Definitions

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

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.