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: Libreoffice-qa@lists.freedesktop.org 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/