Ispirer Website Ispirer Toolkit Overview Free Trial

HP Neoview Data Types - INT, INTEGER

Versions: HP Neoview 2.4, 2.3 and 2.2

HP Neoview - INT
Syntax INT [SIGNED | UNSIGNED]
Data 32-bit integer data
Range Signed: -231 to 231-1 (2G)
Unsigned: 0 to 232-1 (4G)
Default The default is SIGNED
Storage Size 4 bytes
Synonyms INTEGER
Standards ANSI SQL

HP Neoview - 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)
Ingres INTEGER, -231 to 231-1

Related Data Types in HP Neoview

Data Types
Integers LARGEINT SMALLINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT(p) REAL DOUBLE PRECISION

All Data Types


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