Edit

Example SQLGetTypeInfo Result Set

  • Article

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