Ispirer Ispirer
 


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

Informix Dynamic Server (IDS) Data Types - CLOB

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

Infromix - CLOB
Syntax CLOB
Data Variable-length character data (character large object), single-byte and multibyte character sets
Range 4 terabyte (4*240 bytes)
Standards Informix SQL Extension

Example:

CREATE TABLE t_clob (c1 CLOB);

Informix CLOB - 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 TEXT

All Data Types


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

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