Ispirer Ispirer
 


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

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


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

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