Ispirer Website Ispirer Capabilities - Informix Migration Free Trial

Informix Dynamic Server (IDS) Data Types - BIGINT

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

Informix - BIGINT
Syntax BIGINT
Data 64-bit integer data
Range -263 to 263-1
Storage Size 8 bytes
Synonyms INT8 (BIGINT has storage and processing advantages over INT8)
Standards ANSI SQL

Example:

CREATE TABLE t_bigint (c1 BIGINT);

Informix BIGINT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(19,0), -1019-1 to 1019-1
SQL Server BIGINT, -263 to 263-1
MySQL BIGINT, Signed: -263 to 263-1, Unsigned: 0 to 264-1
PostgreSQL BIGINT, -263 to 263-1
Sybase ASE BIGINT, Signed: -263 to 263-1, Unsigned: 0 to 264-1
HP Neoview LARGEINT, -263 to 263-1
Ingres BIGINT, -263 to 263-1

Related Data Types in Informix

Data Types
Integers INT SMALLINT
Auto-increment integers BIGSERIAL SERIAL
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT(p) REAL, SMALLFLOAT DOUBLE PRECISION

All Data Types


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