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