Ispirer Website Ispirer Capabilities - Informix Migration Free Trial

Informix Dynamic Server (IDS) Data Types - BLOB

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

Infromix - BLOB
Syntax BLOB
Data Variable-length binary data (binary large object)
Range 4 terabyte (4*240 bytes)
Standards Informix SQL Extension

Example:

CREATE TABLE t_byte (c1 BLOB);

Informix BLOB - Equivalents in Other Databases

Database Data Type and Conversion
Oracle BLOB, 4G
SQL Server VARBINARY(max), 2G, IMAGE, 2G
MySQL LONGBLOB ,4G
PostgreSQL BYTEA ,2G
Sybase ASE IMAGE ,2G

Related Data Types in Informix

Data Types
Binary large objects BYTE

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.