Example SQLGetTypeInfo Result Set
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 |
