Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Neoview Request SQLWays

HP Neoview - Data Types

Versions: HP Neoview 2.4, 2.3 and 2.2

Data Type Parameters and Range
Character Data Types
CHAR(n) - Fixed-length character data 1 ⇐ n ⇐ (32708 - size of other columns), default is 1
NCHAR(n) - Fixed-length character data in Unicode (UCS-2) or ISO88591 (Latin1) 1 ⇐ n ⇐ (32708 - size of other columns), default is 1
VARCHAR(n) - Variable-length character data 1 ⇐ n ⇐ (32708 - size of other columns), n is mandatory
NVARCHAR(n) - Variable-length character data in Unicode (UCS-2) or ISO88591 (Latin1) 1 ⇐ n ⇐ (32708 - size of other columns), n is mandatory
Integer Data Types
LARGEINT - 64-bit integer data -263 to 263-1
INT, INTEGER - 32-bit integer data Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)
SMALLINT - 16-bit integer data Signed: -32768 to 32767, Unsigned: 0 to 65535
Decimal Data Types
NUMERIC(p,s) - Fixed-point numeric data 1 ⇐ p ⇐ 128, default is 9; 0 ⇐ s ⇐ p, default is 0
DECIMAL(p,s) - Fixed-point numeric data (stored as ASCII characters) 1 ⇐ p ⇐ 18, default is 9; 0 ⇐ s ⇐ p, default is 0
Floating-Point Data Types
FLOAT(p) - Floating-point numeric data +/-2.22e-308 to +/-1.79e+308
1 ⇐ p ⇐ 54, default is 54
REAL - 32-bit floating-point numeric data +/-1.17e-38 to +/-3.40e+38
DOUBLE PRECISION - 64-bit floating-point numeric data +/-2.22e-308 to +/-1.79e+308
Date and Time Data Types
DATE - Date data (year, month and day) January 01, 0001 to December 31, 9999
TIME(p) - Time data (hours, minutes, seconds and fraction of seconds) 00:00:00.000000 to 23:59:59.999999
0 ⇐ p ⇐ 6 (microseconds), default is 0
TIMESTAMP(p) - Date and time data (day, month, year, hours, minutes,
seconds and fractional seconds)
January 01, 0001 00:00:00.000000 to December 31, 9999 23:59:59.999999
0 ⇐ p ⇐ 6 (microseconds), default is 6
INTERVAL year-month - Period of time (year-month interval) Interval units: year and month
INTERVAL day-time - Period of time (day-time interval) Interval units: day, hour, minute, second and fraction of seconds

Data Types in Other Databases


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Neoview Request SQLWays

sqlways/neoview/data-types.txt · Last modified: March 20, 2013, 03:58:22 AM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement