Ispirer Website Ispirer Capabilities - Informix Migration Free Trial

Informix Dynamic Server (IDS) Data Types - DOUBLE PRECISION

Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x

Informix - DOUBLE PRECISION
Syntax DOUBLE PRECISION
Data 64-bit floating-point numeric data
Range 1E-308 to 1E+308
Notes DOUBLE PRECISION is equivalent to FLOAT
Storage Size 8 bytes
Standards ANSI SQL

Example:

CREATE TABLE t_double (c1 DOUBLE PRECISION);

Informix DOUBLE PRECISION - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER, BINARY_DOUBLE
SQL Server DOUBLE PRECISION
MySQL DOUBLE, DOUBLE PRECISION
PostgreSQL DOUBLE PRECISION
Sybase ASE DOUBLE PRECISION
HP Neoview DOUBLE PRECISION

Related Data Types in Informix

Data Types
Integers BIGINT INT SMALLINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT(p) REAL, SMALLFLOAT

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.