You are here:

Data type mapping: SQL Server

This page includes information about how SQL server data types are converted to Querix 4gl data types and Informix SQL data type (and vice verse).

Converting SQL Server to Informix

SQL Server data types	Querix 4gl data types	Informix SQL data types
BIGINT	INT / INT8	INT8
INT	INT	INT
SMALLINT	SMALLINT	SMALLINT
TINYINT	SMALLINT	SMALLINT
BIT	SMALLINT	SMALLINT
DECIMAL	DECIMAL (DEC, NUMERIC)	DECIMAL
MONEY	MONEY	MONEY
SMALLMONEY	MONEY	MONEY
FLOAT	SMALLFLOAT (REAL)	SMALLFLOAT
REAL	FLOAT (DOUBLE PRECISION)	FLOAT
DATETIME	DATETIME YEAR TO FRACTION(3)	DATETIME YEAR TO FRACTION(3)	NBDefault mapping is assumed to be DATETIME, unless the QX_$SCHEMA states otherwise.
SMALLDATETIME	DATETIME YEAR TO SECOND	DATETIME YEAR TO SECOND	NBDefault mapping is assumed to be DATETIME, unless the QX_$SCHEMA states otherwise.
CHAR	CHAR	CHAR
VARCHAR	VARCHAR	LVARCHAR	NBIn Informix, VARCHAR is limited to a maximum length of 255. In SQL Server, VARCHAR has an 8000 character limit.
NCHAR	NCHAR	NCHAR
NVARCHAR	NVARCHAR	NVARCHAR
NTEXT	TEXT	TEXT	NBIn SQL Server, NTEXT stored Unicode data. In Informix, TEXT stores fixed 8-bit encoded data.
BINARY	BYTE	BYTE
VARBINARY	BYTE	BYTE
IMAGE	BYTE	BYTE
UNIQUEIDENTIFIER	CHAR(36)	CHAR(36)	NBFixed format globally unique identifier. Uses the format "xxxxxxxx-xxxxxxxx-xxxxxxxxxxxxxxxx" where 'x' is a hexadecimal digit.

Informix SQL data types	Querix 4gl data types	SQL Server data types
CHAR	CHAR	CHAR
VARCHAR	VARCHAR	VARCHAR	NBIn Informix, VARCHAR is restricted to 255 characters.
LVARCHAR	VARCHAR	VARCHAR
NCHAR	NCHAR	NCHAR	NBIn SQL Server, NCHAR is a fixed 16-bit encoding, whereas in Informix, NCHAR is based on variable width encodings.
NVARCHAR	NVARCHAR	NVARCHAR	NBIn SQL Server, NCHAR is a fixed 16-bit encoding, whereas in Informix, NCHAR is based on variable width encodings.
SMALLINT	SMALLINT	SMALLINT
INTEGER	INTEGER (INT)	INT
INTEGER8	INT8	BIGINT
SERIAL	INTEGER (INT)	INTEGER IDENTITY
SERIAL8	INT8	BIGINT IDENTITY
FLOAT	FLOAT (DOUBLE PRECISION)	REAL
SMALLFLOAT	SMALLFLOAT (REAL)	FLOAT
DOUBLE PRECISION	FLOAT (DOUBLE PRECISION)	REAL
DECIMAL	DECIMAL (DEC, NUMERIC)	DECIMAL
MONEY	MONEY	DECIMAL	NBIn Informix, MONEY is the range equivalent to DECIMAL. Even though SQL Server has a MONEY datatype, it doesn't cover the range of values available to an Informix MONEY.
DATE	DATE	DATETIME
DATETIME	DATETIME	DATETIME / DATETIME2	NBIn Informix, DATETIME has a maximum precision of FRACTION(5).
INTERVAL	INTERVAL	FLOAT	NBEmulated type.
BYTE	BYTE	IMAGE
TEXT	TEXT	VARCHAR(MAX)
BOOLEAN	BOOLEAN	BIT