Ispirer Ispirer
 


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

Ingres Data Types - BIGINT

Versions: Ingres 9.x and 10.0

Ingres - BIGINT
Syntax BIGINT
Data 64-bit integer data
Range -263 to 263-1
Storage Size 8 bytes
Standards ANSI SQL

Ingres 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
Informix BIGINT, -263 to 263-1
HP Neoview LARGEINT, -263 to 263-1

Related Data Types in Ingres

Data Types
Integers INTEGER SMALLINT TINYINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT REAL

All Data Types


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

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