An application calls SQLGetTypeInfo to determine which data types are supported by a data source and the characteristics of those data types. The following tables show a sample result set returned by SQLGetTypeInfo for a data source that supports SQL_CHAR, SQL_LONGVARCHAR, SQL_DECIMAL, SQL_REAL, SQL_DATETIME, SQL_INTERVAL_YEAR, and SQL_INTERVAL_DAY_TO_SECOND.
|
TYPE_NAME
|
DATA_TYPE
|
COLUMN_SIZE
|
LITERAL_PREFIX
|
LITERAL_SUFFIX
|
CREATE_PARAMS
|
NULLABLE
|
|---|
|
"char"
|
SQL_CHAR
|
255
|
"'"
|
"'"
|
"length"
|
SQL_TRUE
|
|
"text"
|
SQL_LONGVARCHAR
|
2147483647
|
"'"
|
"'"
|
<Null>
|
SQL_TRUE
|
|
"decimal"
|
SQL_DECIMAL
|
28
|
<Null>
|
<Null>
|
"precision,
scale"
|
SQL_TRUE
|
|
"real"
|
SQL_REAL
|
7
|
<Null>
|
<Null>
|
<Null>
|
SQL_TRUE
|
|
"datetime"
|
SQL_TYPE_TIMESTAMP
|
23
|
"'"
|
"'"
|
<Null>
|
SQL_TRUE
|
|
"INTERVAL YEAR() TO YEAR"
|
SQL_INTERVAL_YEAR
|
9
|
"'"
|
"'"
|
"precision"
|
SQL_TRUE
|
|
"INTERVAL DAY() TO FRACTION(5)"
|
SQL_INTERVAL_DAY_TO_SECOND
|
24
|
"'"
|
"'"
|
"precision"
|
SQL_TRUE
|
|
DATA_TYPE
|
CASE_SENSITIVE
|
SEARCHABLE
|
UNSIGNED_ATTRIBUTE
|
FIXED_PREC_SCALE
|
AUTO_UNIQUE_VALUE
|
LOCAL_TYPE_NAME
|
|---|
|
SQL_CHAR
|
SQL_FALSE
|
SQL_SEARCHABLE
|
<Null>
|
SQL_FALSE
|
<Null>
|
"char"
|
|
SQL_LONGVARCHAR
|
SQL_FALSE
|
SQL_PRED_CHAR
|
<Null>
|
SQL_FALSE
|
<Null>
|
"text"
|
|
SQL_DECIMAL
|
SQL_FALSE
|
SQL_PRED_BASIC
|
SQL_FALSE
|
SQL_FALSE
|
SQL_FALSE
|
"decimal"
|
|
SQL_REAL
|
SQL_FALSE
|
SQL_PRED_BASIC
|
SQL_FALSE
|
SQL_FALSE
|
SQL_FALSE
|
"real"
|
|
SQL_TYPE_TIMESTAMP
|
SQL_FALSE
|
SQL_SEARCHABLE
|
<Null>
|
SQL_FALSE
|
<Null>
|
"datetime"
|
|
SQL_INTERVAL_YEAR
|
SQL_FALSE
|
SQL_SEARCHABLE
|
<Null>
|
SQL_FALSE
|
<Null>
|
"INTERVAL YEAR() TO YEAR"
|
|
SQL_INTERVAL_DAY_TO_SECOND
|
SQL_FALSE
|
SQL_PRED_BASIC
|
<Null>
|
SQL_FALSE
|
<Null>
|
"INTERVAL DAY() TO FRACTION(5)"
|
|
DATA_TYPE
|
MINIMUM_SCALE
|
MAXIMUM_SCALE
|
SQL_DATA_TYPE
|
SQL_DATETIME_SUB
|
NUM_PREC_RADIX
|
INTERVAL_PRECISION
|
|---|
|
SQL_CHAR
|
<Null>
|
<Null>
|
SQL_CHAR
|
<Null>
|
<Null>
|
<Null>
|
|
SQL_LONGVARCHAR
|
<Null>
|
<Null>
|
SQL_LONGVARCHAR
|
<Null>
|
<Null>
|
<Null>
|
|
SQL_DECIMAL
|
0
|
28
|
SQL_DECIMAL
|
<Null>
|
10
|
<Null>
|
|
SQL_REAL
|
<Null>
|
<Null>
|
SQL_REAL
|
<Null>
|
10
|
<Null>
|
|
SQL_TYPE_TIMESTAMP
|
3
|
3
|
SQL_DATETIME
|
SQL_CODE_TIMESTAMP
|
<Null>
|
12
|
|
SQL_INTERVAL_YEAR
|
0
|
0
|
SQL_INTERVAL
|
SQL_CODE_INTERVALYEAR
|
<Null>
|
9
|
|
SQL_INTERVAL_DAY_TO_SECOND
|
5
|
5
|
SQL_INTERVAL
|
SQL_CODE_INTERVALDAY_TO_SECOND
|
<Null>
|
9
|