Ispirer Website
Ispirer Capabilities - Informix Migration
Free Trial
Informix Dynamic Server (IDS) Data Types - REAL, SMALLFLOAT
Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x
Informix - REAL | |
---|---|
Syntax | REAL |
Data | 32-bit floating-point numeric data |
Range | 1E-38 to 1E+37 |
Synonyms | SMALLFLOAT |
Storage Size | 4 bytes |
Standards | ANSI SQL |
Example:
CREATE TABLE t_real (c1 REAL);
Informix REAL - Equivalents in Other Databases
Database | Data Type and Conversion | |
---|---|---|
Oracle | FLOAT(24) | BINARY_FLOAT |
SQL Server | REAL | |
MySQL | REAL(p,s) | |
PostgreSQL | REAL | |
Sybase ASE | REAL | |
HP Neoview | REAL | |
Ingres | REAL |
Related Data Types in Informix
Data Types | |||
---|---|---|---|
Integers | BIGINT | INT | SMALLINT |
Fixed-point | DECIMAL(p,s) | NUMERIC(p,s) | |
Floating-point | FLOAT(p) | DOUBLE PRECISION |
All Data Types