Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

Informix Dynamic Server (IDS) Data Types - DECIMAL, NUMERIC

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

Informix - DECIMAL
Syntax DECIMAL[(p[,s])]
Data Fixed-point numeric 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 0
Synonym DEC
Standards ANSI SQL

NUMERIC is identical to DECIMAL

Informix - NUMERIC
Standards ANSI SQL

Example:

CREATE TABLE t_dec 
 (
   c1 DECIMAL(3,1)
 );

Informix DECIMAL/NUMERIC - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(p,s), 1 ⇐ p ⇐ 38, -84 ⇐ s ⇐ 127
SQL Server DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 38, 0 ⇐ s ⇐ p
MySQL DECIMAL(p,s,), NUMERIC(p,s), 1 ⇐ p ⇐ 65, 0 ⇐ s ⇐ 30
PostgreSQL DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 1000, 0 ⇐ s ⇐ p
Sybase ASE DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 38, 0 ⇐ s ⇐ p
HP Neoview DECIMAL(p,s), 1 ⇐ p ⇐ 18, 0 ⇐ s ⇐ p, NUMERIC(p,s), 1 ⇐ p ⇐ 128, 0 ⇐ s ⇐ p
Ingres DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 39, 0 ⇐ s ⇐ p

Related Data Types in Informix

Data Types
Integers BIGINT INT SMALLINT
Floating-point FLOAT(p) REAL, SMALLFLOAT DOUBLE PRECISION

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

sqlways/informix/data-types/decimal_numeric.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2021, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement