Ispirer Ispirer
 


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

Informix Dynamic Server (IDS) Data Types - BYTE

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

Infromix - BYTE
Syntax BYTE
Data Variable-length binary data (binary large object)
Range 2G
Standards Informix SQL Extension

Example:

CREATE TABLE t_byte (c1 BYTE);

Informix BYTE - 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 BLOB

All Data Types


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

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