Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

sqlways/informix/data-types.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement