User Documentation
Ispirer Capabilities - HiRDB Migration
Pricing
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