Special Values Supported by Database Data Types
| Type | Database | NaN | sNaN | Infinity/-Infinity |
|---|---|---|---|---|
DECFLOAT |
DB2 (All Platform) | Yes | Yes | Yes |
BINARY FLOAT |
Oracle, TimesTen | Yes | No | Yes |
BINARY DOUBLE |
Oracle, TimesTen | Yes | No | Yes |
REAL |
PostgreSQL, Teradata | Yes | No | Yes |
DOUBLE |
PostgreSQL, Teradata | Yes | No | Yes |
NUMERIC |
PostgreSQL | Yes | No | Yes |
NUMBER |
Oracle | No | No | Yes |
NOT CURRENTLY SUPPORTED |
Sybase, MySQL, MariaDB, Aurora, Azure, c-tree, MS SQL Server, Informix, HP SQL/MP | No | No | No |