SQL Data Type | C Definitions for Data Types Returned or Set in sqltype and sqlindtype | Value |
UNKNOWN | SQL_TYP_UNKNOWN | 0 |
CHAR | SQL_TYP_CHAR | 1 |
NUMERIC | SQL_TYP_NUMERIC | 2 |
DECIMAL | SQL_TYP_DECIMAL | 3 |
INTEGER | SQL_TYP_INTEGER | 4 |
SMALLINT | SQL_TYP_SMALLINT | 5 |
FLOAT | SQL_TYP_FLOAT | 6 |
LARGEINT | SQL_TYP_LARGEINT | 9 |
VARCHAR | SQL_TYP_VARCHAR | 12 |
NUMERIC SIGNED LEADING | SQL_TYP_NUMERIC_LD | 20 |
NUMERIC SIGNED TRAILING | SQL_TYP_NUMERIC_TR | 21 |
NUMERIC SIGNED LEADING SEPARATE | SQL_TYP_NUMERIC_SLD | 22 |
NUMERIC SIGNED LEADING TRAILING | SQL_TYP_NUMERIC_STR | 23 |
NULLABLE_CHAR | SQL_TYP_NCHAR | -1 |
NULLABLE NUMERIC | SQL_TYP_NNUMERIC | -2 |
NULLABLE DECIMAL | SQL_TYP_NDECIMAL | -3 |
NULLABLE INTEGER | SQL_TYP_NINTEGER | -4 |
NULLABLE SMALLINT | SQL_TYP_NSMALLINT | -5 |
NULLABLE FLOAT | SQL_TYP_NFLOAT | -6 |
NULLABLE LARGEINT | SQL_TYP_NLARGEINT | -9 |
NULLABLE VARCHAR | SQL_TYP_NVARCHAR | -12 |
NULLABLE NUMERIC SIGNED LEADING | SQL_TYP_NNUMERIC_LD | -20 |
NULLABLE NUMERIC SIGNED TRAILING | SQL_TYP_NNUMERIC_TR | -21 |
NULLABLE NUMERIC SIGN LEADING | SQL_TYP_NNUMERIC_SLD | -22 |
NULLABLE NUMERIC SIGN TRAILING | SQL_TYP_NNUMERIC_STR | -23 |
BINARY | SQL_TYP_BINARY | -51 |
NULLABLE BINARY | SQL_TYP_NBINARY | -52 |
NATURAL DATE | SQL_TYP_NATDATE | -53 |
NULLABLE NATURAL DATE | SQL_TYP_NNATDATE | -54 |
NATURAL TIME | SQL_TYP_NATTIME | -55 |
NULLABLE NATURAL TIME | SQL_TYP_NNATTIME | -56 |
SQLDA | SQL_TYP_SQLDA | -57 |
NATURAL TIMESTAMP | SQL_TYP_NATTIMESTAMP | -58 |
NULLABLE NATURAL TIMESTAMP | SQL_TYP_NNATTIMESTAMP | -59 |