Data type conversion table: Informix to SQL Server

Table 1. Data type conversion table (Informix to SQL Server)
Informix® data types Microsoft™ SQL Server data types
CHAR(n) CHAR(n) if SBCS, NCHAR(n) if UTF-8
VARCHAR(n[,m]) VARCHAR(n) if SBCS, NVARCHAR(n) if UTF-8
LVARCHAR(n) VARCHAR(n) if SBCS, NVARCHAR(n) if UTF-8
NCHAR(n) NCHAR(n) (UNICODE, max is 4000 chars)
NVARCHAR(n[,m]) NVARCHAR(n) (UNICODE, max is 4000 chars)
BOOLEAN BIT
SMALLINT SMALLINT
INTEGER INTEGER
BIGINT BIGINT
INT8 BIGINT
SERIAL[(start)] INTEGER (see note 1)
BIGSERIAL[(start)] BIGINT (see note 1)
SERIAL8[(start)] BIGINT (see note 1)
DOUBLE PRECISION / FLOAT[(n)] FLOAT(n)
REAL / SMALLFLOAT REAL
DECIMAL(p,s) DECIMAL(p,s)
DECIMAL(p) with p<=19 DECIMAL(2*p,p)
DECIMAL(p) with p>19 N/A
DECIMAL DECIMAL(32,16)
MONEY(p,s) DECIMAL(p,s)
MONEY(p) DECIMAL(p,2)
MONEY DECIMAL(16,2)
DATE DATE
DATETIME HOUR TO SECOND TIME(0)
DATETIME HOUR TO FRACTION(n) TIME(n)
DATETIME YEAR TO SECOND DATETIME2(0)
DATETIME q1 TO q2 (different from above) DATETIME2(n)
INTERVAL q1 TO q2 CHAR(50)
TEXT VARCHAR(MAX)
BYTE VARBINARY(MAX)
Notes:
  1. For more details about serial emulation, see SERIAL data types.