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 MINUTE TIME(0)
DATETIME HOUR TO SECOND TIME(0)
DATETIME HOUR TO FRACTION(n) TIME(n)
DATETIME YEAR TO MONTH DATETIME2(0)
DATETIME YEAR TO DAY DATETIME2(0)
DATETIME YEAR TO HOUR DATETIME2(0)
DATETIME YEAR TO MINUTE DATETIME2(0)
DATETIME YEAR TO SECOND DATETIME2(0)
DATETIME YEAR TO FRACTION(n) DATETIME2(n)
INTERVAL q1 TO q2 CHAR(50)
TEXT VARCHAR(MAX)
BYTE VARBINARY(MAX)
Notes:
  1. For more details about serial emulation, see SERIAL and BIGSERIAL data types.