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 (signed)
0 to 255
Small Integer
[SMALLINT]
5
-32,768 to 32,767
Integer
[MEDIUMINT]
7
Integer
[INTEGER]
10
-2,147,483,648 to 2,147,483,647
Integer
[INT]
10
BigInt
[BIGINT]
19
-9,223,372,036,854,775,808 to
9,223,372,036,854,775,807
I have some questions about them.
1) What is the difference between [INT] and [INTEGER]?
2) Do they have the same range?
3) What purpose does each of these field types serve?
4) Is there a link that describes the information for all of the field
types used by the Table Design dialog?
5) What is the range for [MEDIUMINT]?
--Dan
_______________________________________________
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/