SQL data types

Value Type
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_DATETIME (ODBC 3.0 only)
12 SQL_VARCHAR