Release date: September 2013
Standard IBM® Informix® SQL data types have corresponding IBM Informix ODBC Driver data types.
| Informix SQL data type | Informix ODBC driver SQL data type (fSqlType) | Description |
|---|---|---|
| BIGINT | SQL_INFX_BIGINT | Signed numeric value with precision 10, scale 0,
and range n (–(263 - 1) ≤ n ≤ 263 – 1) |
| BIGSERIAL | SQL_INFX_BIGINT | Sequential positive integers to 263 – 1) |
| BOOLEAN | SQL_BIT | ‘t' or ‘f' |
| BYTE | SQL_LONGVARBINARY | Binary data of variable length |
| CHAR(n), CHARACTER(n) | SQL_CHAR | Character string of fixed length n (1 ≤ n ≤ 32,767) |
| CHARACTER VARYING(m, r) | SQL_VARCHAR | Character string of variable length with maximum length m (1 ≤ m ≤ 255) and minimum amount of reserved space r (0 ≤ r < m) |
| DATE | SQL_DATE | Calendar date |
| DATETIME | SQL_TIMESTAMP | Calendar date and time of day |
| DEC(p,s), DECIMAL(p, s) | SQL_DECIMAL | Signed numeric value with precision p and scale s: (1 ≤ p ≤ 32; 0 ≤ s ≤ p) Important:
|
| DOUBLE PRECISION | SQL_DOUBLE | Signed numeric value with the same characteristics as the standard C double data type |
| FLOAT | SQL_DOUBLE | Signed numeric value with the same characteristics as the standard C double data type |
| IDSSECURITYLABEL | Built-in DISTINCT OF VARCHAR(128) data type; use is restricted to label-based access control | |
| INT, INTEGER | SQL_INTEGER | Signed numeric value with precision 10, scale 0,
and range n (-2,147,483,647 ≤ n ≤ 2,147,483,647) |
| INT8 | SQL_BIGINT | Signed numeric value with precision 10, scale 0,
and range n (–(263 - 1) ≤ n ≤ 263 – 1) |
| INTERVAL MONTH(p) | SQL_INTERVAL_MONTH | Number of months between two dates; p is the interval leading precision. |
| INTERVAL YEAR(p) | SQL_INTERVAL_YEAR | Number of years and months between two dates; p is the interval leading precision. |
| INTERVAL YEAR(p) TO MONTH | SQL_INTERVAL_YEAR_TO_MONTH | Number of years and months between two dates; p is the interval leading precision. |
| INTERVAL DAY(p) | SQL_INTERVAL_DAY | Number of days between two dates; p is the interval leading precision. |
| INTERVAL HOUR(p) | SQL_INTERVAL_HOUR | Number of hours between two date times; p is the interval leading precision. |
| INTERVAL MINUTE(p) | SQL_INTERVAL_MINUTE | Number of minutes between two date/times; p is the interval leading precision. |
| INTERVAL SECOND(p,q) | SQL_INTERVAL_SECOND | Number of seconds between two date/times; p is the interval leading precision and q is the interval seconds precision. |
| INTERVAL DAY(p) TO HOUR | SQL_INTERVAL_DAY_TO_HOUR | Number of days/hours between two date/times; p is the interval leading precision. |
| INTERVAL DAY(p) TO MINUTE | SQL_INTERVAL_DAY_TO_MINUTE | Number of days/hours/minutes between two date/times; p is the interval leading precision. |
| INTERVAL DAY(p) TO SECOND(q) | SQL_INTERVAL_DAY_TO_SECOND | Number of days/hours/minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision. |
| INTERVAL HOUR (p) TO MINUTE | SQL_INTERVAL_HOUR_TO_MINUTE | Number of hours/minutes between two date/times; p is the interval leading precision. |
| INTERVAL HOUR(p) TO SECOND(q) | SQL_INTERVAL_HOUR_TO_SECOND | Number of hours/minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision. |
| INTERVAL MINUTE(p) TO SECOND(q) | SQL_INTERVAL_MINUTE_TO_SECOND | Number of minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision. |
| LVARCHAR | SQL_VARCHAR | Character string of variable length with length l (255 ≤ l ≤ 32,000) When connecting to IBM Informix 10.0 servers with the ODBC driver, the SQLDescribeCol, SQLColAttributes & SQLDescribeParam APIs report the length mentioned during creation of the LVARCHAR column. If no length was mentioned during creation, length defaults to 2048 bytes. |
| MONEY(p, s) | SQL_DECIMAL | Signed numeric value with precision p and scale s (1 ≤ p ≤ 32; 0 ≤ s ≤ p) |
| NUMERIC | SQL_NUMERIC | Signed, exact, numeric value with precision p and scale s (1 ≤ p ≤ 15; 0 ≤ s ≤ p) |
| REAL | SQL_REAL | Signed numeric value with the same characteristics as the standard C float data type |
| SERIAL | SQL_INTEGER | Sequential INTEGER |
| SERIAL8 | SQL_BIGINT | Sequential INT8 |
| SMALLFLOAT | SQL_REAL | Signed numeric value with the same characteristics as the standard C float data type |
| SMALLINT | SQL_SMALLINT | Signed numeric value with precision 5, scale 0,
and range n (–32,767 ≤ n ≤ 32,767) |
| TEXT | SQL_LONGVARCHAR | Character string of variable length |
| VARCHAR(m, r) | SQL_VARCHAR | Character string of variable length with maximum length m (1 ≤ m ≤ 255) and minimum amount of reserved space r (0 ≤ r < m) |