Ispirer Website
Ispirer Capabilities - Informix Migration
Free Trial
Informix Dynamic Server (IDS) Data Types
Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x
Overview
Informix Data Type | Parameters and Range |
---|---|
Character Data Types | |
CHAR(n) - Fixed-length character data | 1 ⇐ n ⇐ 32767, default is 1 |
NCHAR(n) - Fixed-length character data | 1 ⇐ n ⇐ 32767, default is 1 |
VARCHAR(n,r) - Variable-length character data | 1 ⇐ n ⇐ 255, default is 1; 0 ⇐ r ⇐ n, default is 0 |
NVARCHAR(n,r) - Variable-length character data | 1 ⇐ n ⇐ 255, default is 1; 0 ⇐ r ⇐ n, default is 0 |
LVARCHAR(n) - Variable-length character data | 1 ⇐ n ⇐ 32739, default is 2048 |
TEXT - Variable-length character data (large object) | 2G |
CLOB - Variable-length character data (large object) | 4T (4*240) |
Integer Data Types | |
BIGINT, INT8 - 64-bit integer data | -263 to 263-1 |
INT, INTEGER - 32-bit integer data | -231 to 231-1 (2G) |
SMALLINT - 16-bit integer data | -32768 to 32767 |
SERIAL(n) - 32-bit auto-increment integer data | -231 to 231-1 (2G) |
BIGSERIAL(n), SERIAL8(n) - 64-bit auto-increment integer data | -263 to 263-1 |
Decimal Data Types | |
DECIMAL(p,s), NUMERIC(p,s) - Fixed-point numeric data | 1 ⇐ p ⇐ 32, default is 16; 0 ⇐ s ⇐ p, default is 0 |
Floating-Point Data Types | |
FLOAT(p) - 64-bit floating-point numeric data | 1E-308 to 1E+308, p is ignored |
REAL, SMALLFLOAT - 32-bit floating-point numeric data | 1E-38 to 1E+38 |
DOUBLE PRECISION - 64-bit floating-point numeric data | 1E-308 to 1E+308 |
Date and Time Data Types | |
DATE - Date data (year, month and day) | January 01, 0001 to December 31, 9999 |
DATETIME lq TO sq - Date and time data (day, month, year, hours, minutes, seconds and fraction) | January 01, 0001 00:00:00 to December 31, 9999 23:59:59 0 ⇐ fraction ⇐ 5, default is 3 Precision can be specified: YEAR TO DAY, YEAR TO FRACTION(5) etc |
INTERVAL year-month - Period of time (year-month interval) | Interval units: year and month |
INTERVAL day-time - Period of time (day-time interval) | Interval units: day, hour, minute, second and fraction of seconds |
Binary Data Types | |
BYTE - Variable-length binary data (large object) | 2G |
BLOB - Variable-length binary data (large object) | 4T (4*240) |
Other Data Types | |
BOOLEAN - Boolean data | 't', 'f' and NULL |
MONEY(p,s) - Monetary data | 1 ⇐ p ⇐ 32, default is 16; 0 ⇐ s ⇐ p, default is 2 |
Data Types in Other Databases