HSQLDB supports various data types to represent different kinds of data in database tables. Here's a list of the commonly used data types supported by
HSQLDB :
Numeric Data Types :
* TINYINT : 1-byte integer, range from -128 to 127.
* SMALLINT : 2-byte integer, range from -32,768 to 32,767.
* INTEGER or INT : 4-byte integer, range from -2,147,483,648 to 2,147,483,647.
* BIGINT : 8-byte integer, range from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
* DECIMAL(precision, scale) : Fixed-point decimal number, with specified precision and scale.
* NUMERIC(precision, scale) : Alias for DECIMAL.
Character Data Types :
* CHAR(n) : Fixed-length character string with a specified length n.
* VARCHAR(n) : Variable-length character string with a maximum length of n.
* LONGVARCHAR : Variable-length character string with unlimited length (deprecated, use VARCHAR instead).
Binary Data Types :
* BINARY(n) : Fixed-length binary string with a specified length n.
* VARBINARY(n) : Variable-length binary string with a maximum length of n.
* LONGVARBINARY : Variable-length binary string with unlimited length (deprecated, use VARBINARY instead).
Date and Time Data Types :
* DATE : Date value in the format 'YYYY-MM-DD'.
* TIME : Time value in the format 'HH:MM:SS'.
* TIMESTAMP : Date and time value in the format 'YYYY-MM-DD HH:MM:SS'.
Boolean Data Type :
* BOOLEAN or BIT : Boolean value representing true or false.
Other Data Types :
* ARRAY : Array or list of values.
* CLOB : Character large object, for storing large text data.
* BLOB : Binary large object, for storing large binary data.
* UUID : Universally unique identifier.
These are some of the commonly used data types in HSQLDB. Additionally, HSQLDB supports various other specialized data types and user-defined data types. When defining columns in a table, you can choose the appropriate data type based on the nature of the data being stored.
