<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font face="DejaVu Sans"> </font><font face="DejaVu Sans">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. <br>
<br>
</font>
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=ISO-8859-1">
<table height="344" width="701" cellpadding="4" cellspacing="0">
<colgroup><col width="64*"> <col width="55*"> <col width="36*">
<col width="102*"> </colgroup><thead> <tr valign="TOP">
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000; border-right:
none; padding-top: 0.1cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0cm" width="25%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
background: #e6e6e6; widows: 2; orphans: 2" lang="en-US">
<font color="#000000"><font style="font-size: 11pt"
size="2"><i><b>Field Type name</b></i></font></font></p>
</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000; border-right:
none; padding-top: 0.1cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0cm" width="21%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
background: #e6e6e6; widows: 2; orphans: 2" lang="en-US">
<font color="#000000"><font style="font-size: 11pt"
size="2"><i><b>Field Type</b></i></font></font></p>
</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000; border-right:
none; padding-top: 0.1cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0cm" width="14%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
background: #e6e6e6; widows: 2; orphans: 2" lang="en-US">
<font color="#000000"><font style="font-size: 11pt"
size="2"><i><b>Length</b></i></font></font></p>
</td>
<td style="border: 1px solid #000000; padding: 0.1cm"
width="40%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
background: #e6e6e6; widows: 2; orphans: 2" lang="en-US">
<font color="#000000"><font style="font-size: 11pt"
size="2"><i><b>Range</b></i></font></font></p>
</td>
</tr>
</thead> <tbody>
<tr valign="TOP">
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="25%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">Tiny Integer</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="21%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">[TINYINT]</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="14%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">3</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: 1px solid
#000000; padding-top: 0cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0.1cm" width="40%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">-128 to 127 (signed)<br>
0 to 255</font></p>
</td>
</tr>
<tr valign="TOP">
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="25%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">Small Integer</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="21%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">[SMALLINT]</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="14%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">5</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: 1px solid
#000000; padding-top: 0cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0.1cm" width="40%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">-32,768 to 32,767</font></p>
</td>
</tr>
<tr valign="TOP">
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="25%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">Integer</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="21%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">[MEDIUMINT]</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="14%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">7</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: 1px solid
#000000; padding-top: 0cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0.1cm" width="40%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <br>
</p>
</td>
</tr>
<tr valign="TOP">
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="25%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">Integer</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="21%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">[INTEGER]</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="14%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">10</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: 1px solid
#000000; padding-top: 0cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0.1cm" width="40%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">-2,147,483,648 to
2,147,483,647</font></p>
</td>
</tr>
<tr valign="TOP">
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="25%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">Integer</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="21%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">[INT]</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="14%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">10</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: 1px solid
#000000; padding-top: 0cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0.1cm" width="40%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <br>
</p>
</td>
</tr>
<tr valign="TOP">
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="25%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">BigInt</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="21%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">[BIGINT]</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: none;
padding-top: 0cm; padding-bottom: 0.1cm; padding-left:
0.1cm; padding-right: 0cm" width="14%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">19</font></p>
</td>
<td style="border-top: none; border-bottom: 1px solid #000000;
border-left: 1px solid #000000; border-right: 1px solid
#000000; padding-top: 0cm; padding-bottom: 0.1cm;
padding-left: 0.1cm; padding-right: 0.1cm" width="40%">
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; margin-bottom: 0.07cm; widows: 2;
orphans: 2" lang="en-US"> <font style="font-size: 10pt"
size="2">-9,223,372,036,854,775,808 to</font></p>
<p style="margin-left: 0.21cm; margin-right: 0.21cm;
margin-top: 0.07cm; widows: 2; orphans: 2" lang="en-US"> <font
style="font-size: 10pt" size="2">9,223,372,036,854,775,807</font></p>
</td>
</tr>
</tbody>
</table>
<title></title>
<meta name="GENERATOR" content="LibreOffice 3.6 (Linux)">
<style type="text/css">
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm; widows: 0; orphans: 0; page-break-before: auto }
P.western { font-family: "Liberation Sans", sans-serif; font-size: 10pt; so-language: en-US }
A.western:visited { font-family: "Liberation Sans", sans-serif }
A:link { color: #004586; text-decoration: none }
A.western:link { font-family: "Liberation Sans", sans-serif; so-language: zxx; font-style: normal }
A.sdfootnotesym-western { font-family: "DejaVu Serif", serif }
-->
</style><br>
I have some questions about them.<br>
1) What is the difference between [INT] and [INTEGER]?<br>
2) Do they have the same range?<br>
3) What purpose does each of these field types serve?<br>
4) Is there a link that describes the information for all of the
field types used by the Table Design dialog?<br>
5) What is the range for [MEDIUMINT]?<br>
<br>
--Dan<br>
<br>
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=ISO-8859-1">
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=ISO-8859-1">
<title></title>
<meta name="GENERATOR" content="LibreOffice 3.6 (Linux)">
<style type="text/css">
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm; widows: 0; orphans: 0; page-break-before: auto }
P.western { font-family: "Liberation Sans", sans-serif; font-size: 10pt; so-language: en-US }
A.western:visited { font-family: "Liberation Sans", sans-serif }
A:link { color: #004586; text-decoration: none }
A.western:link { font-family: "Liberation Sans", sans-serif; so-language: zxx; font-style: normal }
A.sdfootnotesym-western { font-family: "DejaVu Serif", serif }
-->
</style>
<title></title>
<meta name="GENERATOR" content="LibreOffice 3.6 (Linux)">
<style type="text/css">
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm; widows: 0; orphans: 0; page-break-before: auto }
P.western { font-family: "Liberation Sans", sans-serif; font-size: 10pt; so-language: en-US }
A.western:visited { font-family: "Liberation Sans", sans-serif }
A:link { color: #004586; text-decoration: none }
A.western:link { font-family: "Liberation Sans", sans-serif; so-language: zxx; font-style: normal }
A.sdfootnotesym-western { font-family: "DejaVu Serif", serif }
-->
</style>
</body>
</html>