Ispirer Ispirer
 


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

HiRDB - Data Types

Versions: HiRDB 9.x and earlier

Data Type Parameters and Range
Character Data Types
MCHAR(n) - Fixed-length, mixed character data 1 ⇐ n ⇐ 30000/charsize, default is 1
MVARCHAR(n) - Variable-length, mixed character data 1 ⇐ n ⇐ 32000/charsize, n is mandatory
Numeric Data Types
INT, INTEGER - 32-bit integer data -231 to 231-1 (2G)
DEC(p,s) - Fixed-point numeric data 1 ⇐ p ⇐ 38, default is 15; 0 ⇐ s ⇐ 38, default is 0
FLOAT - Double-precision floating-point numeric data approximately +-4.9×10-324 to +-3.4×10308
SMALLFLT - Single-precision floating-point numeric data approximately +-1.4×10-45 to +-3.4×1038
Date and Time Data Types
TIMESTAMP(p) - Date and time data (day, month, year, hours, minutes,
seconds and fractional seconds)
0000/01/01 00:00:00.0(6) to 9999/12/31 23:59:59.9(6)
p = 0, 2, 4 or 6, default is 0 (microseconds)
INTERVAL YEAR TO DAY - Period of date in years, months and days -9999 years, 11 months, 99 days to 9999 years, 11 months, 99 days
INTERVAL HOUR TO SECOND - Period of time in hours, minutes and seconds -99 hours, 59 minutes, 59 seconds to 99 hours, 59 minutes, 59 seconds
Binary Data Types
BLOB(n) - Variable-length binary data (binary large object) default for n is 2G
BINARY(n) - Variable-length binary data 1 ⇐ n ⇐ 2G, n is mandatory

Data Types in Other Databases


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

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