SQL data type constants

Constants for Informix SQL column data types shows the SQL data type constants for the HCL Informix®. Constants for Informix SQL column data types that are specific to HCL Informix shows the SQL data type constants for the additional data types that are available with the Informix®.
Table 1. Constants for Informix® SQL column data types
SQL data type Defined constant Integer value
CHAR SQLCHAR 0
SMALLINT SQLSMINT 1
INTEGER SQLINT 2
FLOAT SQLFLOAT 3
SMALLFLOAT SQLSMFLOAT 4
DECIMAL SQLDECIMAL 5
SERIAL SQLSERIAL 6
DATE SQLDATE 7
MONEY SQLMONEY 8
DATETIME SQLDTIME 10
BYTE SQLBYTES 11
TEXT SQLTEXT 12
VARCHAR SQLVCHAR 13
INTERVAL SQLINTERVAL 14
NCHAR SQLNCHAR 15
NVARCHAR SQLNVCHAR 16
INT8 SQLINT8 17
BIGSERIAL SQLBIGSERIAL 53
LVARCHAR SQLLVARCHAR 43
BOOLEAN SQLBOOL 45
BIGINT SQLINFXBIGINT 52
BIGSERIAL SQLBIGSERIAL 53
Table 2. Constants for Informix® SQL column data types that are specific to HCL Informix®
SQL data type Defined constant Integer value
SET SQLSET 19
MULTISET SQLMULTISET 20
LIST SQLLIST 21
ROW SQLROW 22
Varying-length opaque type SQLUDTVAR 40
Fixed-length opaque type SQLUDTFIXED 41
SENDRECV (client-side only) SQLSENDRECV 44
Important: The SENDRECV data type has an SQL constant but can only be used in the Informix® ESQL/C program. You cannot define a database column as type SENDRECV.