2.5.190 ODBCType
The ODBCType structure specifies an ODBC data type identifier.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
wTypeSql |
|||||||||||||||||||||||||||||||
wTypeSql (2 bytes): A signed integer that specifies an ODBC data type. The following are example data types supported by ODBC. For more information about ODBC, see [MSDN-OpenDBConnectivity].
|
Value |
SQL Type |
Data Type |
|---|---|---|
|
0x0000 |
SQL_TYPE_NULL |
Undetermined type, data source does not support typed data. Data type determined based on data content: date and time, decimal or text. |
|
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 |
7-digits precision floating-point |
|
0x0008 |
SQL_DOUBLE |
15-digits precision floating-point |
|
0x000B |
SQL_TIMESTAMP |
Date and Time |
|
0x000C |
SQL_VARCHAR |
Variable-length string of ANSI characters |
|
0xFFF9 |
SQL_BIT |
Bit (1 or 0) |
|
0xFFFE |
SQL_BINARY |
Fixed-length binary data |