Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |