The following table lists valid values of SQLTYPE for the extended SQL data types. The table also lists the name and description of the corresponding data type. In the table, precision refers to the total number of digits and scale refers to the number of digits to the right of the decimal point.
Note that the data types used by a given data source may have different names and limits than those listed below. For information about the data types in a specific data source, see the documentation for that data source.
SQLTYPE |
Typical SQL Data Type |
Description |
EDS_SQL_LONGVARCHAR |
LONG VARCHAR |
Variable-length character data. Maximum length is data source-dependent. |
EDS_SQL_BIT |
BIT |
Single-bit binary data. |
EDS_SQL_TINYINT |
TINYINT |
Signed, exact, numeric value with precision 3 and scale 0. |
EDS_SQL_BIGINT |
BIGINT |
Signed, exact, numeric value (–263 ≤ n ≤ 263–1). |
EDS_SQL_BINARY |
BINARY(n) |
Binary data of fixed length n (1 ≤ n ≤ 255). |
EDS_SQL_VARBINARY |
VARBINARY(n) |
Variable-length binary data of maximum length n (1 ≤ n ≤ 255). |
EDS_SQL_LONGVARBINARY |
LONG VARBINARY |
Variable-length binary data. Maximum length is data source-dependent. |
EDS_SQL_DATE |
DATE |
Date data. |
EDS_SQL_TIME |
TIME |
Time data. |
EDS_SQL_TIMESTAMP |
TIMESTAMP |
Date/time data. |
