User Documentation
Ispirer Capabilities - Informix Migration
Pricing
Informix Dynamic Server (IDS) Data Types - MONEY
Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x
| Informix - MONEY | |
|---|---|
| Syntax | MONEY[(p[,s])] |
| Data | Monetary data |
| Parameters | p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the decimal point |
| Range | 1 ⇐ p ⇐ 32, 0 ⇐ s ⇐ p |
| Default | p is 16, s is 2 |
| Notes | Client applications format MONEY values according to the locale. For example, for the US, $ is used as the currency symbol, a comma (,) is used as thousands separator and period (.) is used between the integer and fractional parts |
| Standards | Informix SQL Extension |
Example:
CREATE TABLE t_money (c1 MONEY);
Informix MONEY - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | NUMBER(p,s), 1 ⇐ p ⇐ 38, -84 ⇐ s ⇐ 127 |
| SQL Server | MONEY, -922,337,203,685,477.5808 to 922,337,203,685,477.5807 SMALLMONEY, -214,748.3648 to 214,748.3647 |
| MySQL | DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 65, 0 ⇐ s ⇐ 30 |
| PostgreSQL | MONEY, -92,233,720,368,547,758.08 to 92,233,720,368,547,758.07 |
| Sybase ASE | MONEY, -922,337,203,685,477.5808 to 922,337,203,685,477.5807 SMALLMONEY, -214,748.3648 to 214,748.3647 |
Related Data Types in Informix
| Data Types | |||
|---|---|---|---|
| Fixed-point | DECIMAL(p,s) | NUMERIC(p,s) | |
All Data Types