Ispirer Ispirer
 


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

Ingres Data Types - INTEGER

Versions: Ingres 9.x and 10.0

Ingres - INTEGER
Syntax INTEGER
Data 32-bit integer data
Range -231 to 231-1
Storage Size 4 bytes
Synonyms INTEGER4, I4
Standards ANSI SQL

Ingres INTEGER - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(10,0), -1010-1 to 1010-1
SQL Server INT, -231 to 231-1 (2G)
MySQL INT, Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)
PostgreSQL INT, -231 to 231-1 (2G)
Sybase ASE INT, Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)
Informix INT, -231 to 231-1 (2G)
HP Neoview INT, Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)

Related Data Types in Ingres

Data Types
Integers BIGINT 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/int.txt · Last modified: May 07, 2018, 03:15:28 PM (external edit)
 
© 1999-2022, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement