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

[Dan Lewis]

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 instead of 
bits. (I understand the meaning of both.) Once I saw what you had 
written, I understood how each of these lengths were written: 1 bit for 
the + or -, and the rest of the bits contain the number.
      I also have a copy of the HSQLDB 1.8 user guide on my hard drive 
and have seen this table there also.

--Dan

On 04/19/2013 02:37 PM, Robert Großkopf wrote:
> 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 at 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/