Ispirer Ispirer
 


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

Informix Dynamic Server (IDS) Data Types - TEXT

Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x

Infromix - TEXT
Syntax TEXT
Data Variable-length character data (character large object), single-byte and multibyte character sets
Range 2G
Standards Informix SQL Extension

Example:

CREATE TABLE t_text (c1 TEXT);

Informix TEXT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle CLOB, 4G; NCLOB, 4G, Unicode - UTF-8 or UTF-16
SQL Server VARCHAR(max) or TEXT, 2G
MySQL LONGTEXT, 4G
PostgreSQL TEXT, 1G
Sybase ASE TEXT, 2G
HP Neoview VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)
Ingres LONG VARCHAR, 2G; LONG NVARCHAR, 2G, Unicode - UTF-8

Related Data Types in Informix

Data Types
Fixed-length Character Data CHAR(n) NCHAR(n)
Variable-length Character Data VARCHAR(n,r) NVARCHAR(n,r) LVARCHAR(n)
Character Large Objects CLOB

All Data Types


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

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