Ispirer Website
Ispirer Capabilities - HiRDB Migration
Free Trial

# 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 | -2^{31} to 2^{31}-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×10^{308} |

SMALLFLT - Single-precision floating-point numeric data | approximately +-1.4×10^{-45} to +-3.4×10^{38} |

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**