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]
-32,768 to 32,767
2¹⁶ (16 Bit) (-15 Bit to +15 Bit-1)
[INTEGER][INT]
-2,147,483,648 to 2,147,483,647
2³² (32 Bit) (-31 Bit to +31 Bit-1)
[BIGINT]
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
2⁶⁴ (64 Bit) (-63 Bit to +63 Bit-1)
Hope this will be readable. All types have the same range as the Java-types.
I have some questions about them.
1) What is the difference between [INT] and [INTEGER]?
No difference, see the HSQLDB-description
2) Do they have the same range?
See 1)
3) What purpose does each of these field types serve?
With every type is described, how much memory is needed for it.
4) Is there a link that describes the information for all of the field
types used by the Table Design dialog?
The shown field-types are different when you use different databases.
For the fields-types of the HSQLDB you have to look in the description
of the HSQLDB
5) What is the range for [MEDIUMINT]?
This isn't shown in the GUI, when you open a HSQLDB. I have just opend
LO 4.0.3.1 for have a look. Tis type isn't a type of the HSQLDB. Could
be you have found this type, when connecting to a MySQL-database. The
range of this type is
2²⁴ (24 Bit)
The unsigned versions of the datatype you could not chose with the
HSQLDB. The Java-Integer-Datatypes are all signed.
Regards,
Robert
_______________________________________________
List Name: Libreoffice-qa mailing list
Mail address: [email protected]
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
