Ispirer Website Ispirer Capabilities - Sybase Migration Free Trial

Sybase ASE Data Types - DECIMAL and NUMERIC

Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x

Sybase ASE - NUMERIC
Syntax NUMERIC[(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 -1038 to 1038-1, 1 ⇐ p ⇐ 38, 0 ⇐ s ⇐ p
Default p is 18, s is 0
Storage Size 2-17 bytes depending on p
Standards ANSI SQL

DECIMAL is identical to NUMERIC

Sybase ASE - DECIMAL
Synonyms DEC
Standards ANSI SQL

Sybase ASE NUMERIC/DECIMAL - 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
Informix DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 32, 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 Sybase ASE

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

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.