[Libreoffice-qa] Purposes for the Integer field types in LibO 4.0.2

[Robert Großkopf]

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