User Documentation
Ispirer Capabilities - Informix Migration
Pricing
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