Below is a table of Field Types for Integers, their lengths and ranges
as listed in the LibreOffice 4.0.2.2 Base Table Design dialog.
/*Field Type name*/
/*Field Type*/
/*Length*/
/*Range*/
Tiny Integer
[TINYINT]
3
-128 to 127
Hello Dan,
the list you created I couldn't read so well, so I add a new list:
The data-types of the HSQLDB are defined in the description of the
HSQLDB. You can find the description here:
http://www.hsqldb.org/doc/1.8/guide/
[TINYINT]
-128 to 127
2⁸ (8 Bit) (-7 Bit to +7 Bit-1)
[SMALLINT]
Hello Robert,
Thanks for the quick reply. You were right: I had a MySQL database
when opened a table in Design View to see what the Field Types were in
LO 4.0.2.2. I found MEDIUMINT when I searched my user guide for MySQL.
It listed the lengths for these field types in terms of Bytes