SQL ODBC Types
|
Type Indicator |
SQL Data Type |
|---|---|
| -10 | SQL_LONGUNICODE |
| -9 | SQL_NVARCHAR |
|
-7 |
SQL_BIT |
|
-6 |
SQL_TINYINT |
|
-5 |
SQL_BIGINT |
|
-4 |
SQL_LONGVARBINARY |
|
-3 |
SQL_VARBINARY |
|
-2 |
SQL_BINARY |
|
-1 |
SQL_LONGVARCHAR |
|
0 |
SQL_UNKNOWN_TYPE |
|
1 |
SQL_CHAR |
|
2 |
SQL_NUMERIC |
|
3 |
SQL_DECIMAL |
|
4 |
SQL_INTEGER |
|
5 |
SQL_SMALLINT |
|
6 |
SQL_FLOAT |
|
7 |
SQL_REAL |
|
8 |
SQL_DOUBLE |
|
9 |
SQL_DATE |
|
10 |
SQL_TIME |
|
11 |
SQL_TIMESTAMP |
|
12 |
SQL_VARCHAR |
