ODBC Navigator 1.0 Home

ODBC data types

TypeVersion<3.0Version>=3.0
SQL_UNKNOWN_TYPE0
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_DATETIME 9
SQL_TIME 10
SQL_TIMESTAMP11
SQL_VARCHAR 12
SQL_TYPE_DATE  91
SQL_TYPE_TIME  92
SQL_TYPE_TIMESTAMP 93
SQL_LONGVARCHAR -1
SQL_BINARY -2
SQL_VARBINARY -3
SQL_LONGVARBINARY-4
SQL_BIGINT -5
SQL_TINYINT -6
SQL_BIT -7
SQL_GUID -11
SQL_INTERVAL_YEAR -80101
SQL_INTERVAL_MONTH -81102
SQL_INTERVAL_DAY -82103
SQL_INTERVAL_HOUR -83104
SQL_INTERVAL_MINUTE -84105
SQL_INTERVAL_SECOND -85106
SQL_INTERVAL_YEAR_TO_MONTH -86107
SQL_INTERVAL_DAY_TO_HOUR -87108
SQL_INTERVAL_DAY_TO_MINUTE -88109
SQL_INTERVAL_DAY_TO_SECOND -89110
SQL_INTERVAL_HOUR_TO_MINUTE -90111
SQL_INTERVAL_HOUR_TO_SECOND -91112
SQL_INTERVAL_MINUTE_TO_SECOND-92113
SQL_UNICODE -95 -8
SQL_UNICODE_VARCHAR -96 -9
SQL_UNICODE_LONGVARCHAR-97-10

Copyright © 2000 HardSign