Ispirer Website Ispirer Toolkit Overview Free Trial

HP Neoview Data Types - SMALLINT

Versions: HP Neoview 2.4, 2.3 and 2.2

HP Neoview - SMALLINT
Syntax SMALLINT [SIGNED | UNSIGNED]
Data 16-bit integer data
Range Signed: -32768 to 32767
Unsigned: 0 to 65535
Default The default is SIGNED
Storage Size 2 bytes
Standards ANSI SQL

HP Neoview SMALLINT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(5,0), -105-1 to 105-1
SQL Server SMALLINT, -32768 to 32767
MySQL SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
PostgreSQL SMALLINT, -32768 to 32767
Sybase ASE SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
Informix SMALLINT, -32768 to 32767
Ingres SMALLINT, -32768 to 32767; TINYINT, -128 to 127

Related Data Types in HP Neoview

Data Types
Integers LARGEINT INT
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.