FLOAT Data Type - Informix to SQL Server Migration

In Informix, the FLOAT data type stores approximate double precision floating point numbers. In SQL Server you can also use the FLOAT data type.

Informix allows you to specify the precision FLOAT(n), where n is a number between 1 and 14, but it is ignored.

Informix:

  CREATE TABLE specs
  (
    value   FLOAT,
    value2 FLOAT(5),
    value3 FLOAT(14)
  );

SQL Server:

  CREATE TABLE specs
  (
    value   FLOAT,
    value2 FLOAT,
    value3 FLOAT
  );

Overview

Conversion summary:

	Informix	SQL Server
Syntax	FLOAT[(p)]	FLOAT[(p)]
Synonyms	DOUBLE PRECISION	DOUBLE PRECISION
Parameter	1 <= p <= 14	p is the number of bits for the mantissa	1 <= p <= 53
Default		p is 53