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

[Dan Lewis]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/libreoffice-qa/attachments/20130419/6b897483/attachment-0001.html>