2.5.152 TypeSql
The TypeSql signed integer specifies the SQL data type. Example data types supported by ODBC are specified in the following table. For more information about ODBC, see [MSDN-OpenDBConnectivity].
|
Value |
SQL Type |
Data Type |
|---|---|---|
|
0x0001 |
SQL_CHAR |
Fixed-length string of ANSI characters . |
|
0x0003 |
SQL_DECIMAL |
Fixed-precision, Fixed-scale numbers. |
|
0x0004 |
SQL_INTEGER |
32-bit signed integer. |
|
0x0005 |
SQL_SMALLINT |
16-bit signed integer. |
|
0x0006 |
SQL_FLOAT |
User-specified precision floating-point. |
|
0x0007 |
SQL_REAL |
Single-precision floating-point. |
|
0x0008 |
SQL_DOUBLE |
Double-precision floating-point. |
|
0x000B |
SQL_TIMESTAMP |
Date and Time. |
|
0x000C |
SQL_VARCHAR |
Variable-length string of characters . |
|
0xFFF9 |
SQL_BIT |
Bit (1 or 0). |
|
0xFFFE |
SQL_BINARY |
Fixed-length binary data. |