Difference between revisions of "Base/Data Types"
From Apache OpenOffice Wiki
< Base
(→Alphanumeric Types) |
(→Numeric Types) |
||
Line 12: | Line 12: | ||
|- | |- | ||
− | | | + | | <center>BOOLEAN</center> |
− | | yes/no | + | | <center>yes / no</center> |
− | | | + | | <center>1</center> |
| <center><nowiki>----</nowiki></center> | | <center><nowiki>----</nowiki></center> | ||
− | | <center>0 | + | | <center>0,1</center> |
|- | |- | ||
− | | | + | | <center>TINYINT</center> |
− | | | + | | <center>tiny integer</center> |
− | | 1 | + | | <center>1</center> |
− | | <center> | + | | <center>no</center> |
| <center>0 - 255</center> | | <center>0 - 255</center> | ||
|- | |- | ||
− | | | + | | <center>SMALLINT</center> |
− | | | + | | <center>small integer</center> |
− | | 2 | + | | <center>2</center> |
− | | <center> | + | | <center>yes</center> |
− | | <center>2<sup>15 | + | | <center>-2<sup>15</sup> to 2<sup>15</sup>-1 </center> |
|- | |- | ||
− | | | + | | <center>INTEGER</center> |
− | | | + | | <center>integer</center> |
− | | 4 | + | | <center>4</center> |
− | | <center> | + | | <center>yes</center> |
− | | <center>2<sup>31 | + | | <center>-2<sup>31</sup> to 2<sup>31</sup>-1 </center> |
|- | |- | ||
− | | | + | | <center>BIGINT</center> |
− | | | + | | <center>big integer</center> |
− | | 8 | + | | <center>8</center> |
− | | <center> | + | | <center>yes</center> |
− | | <center>2<sup>63 | + | | <center>-2<sup>63</sup> to 2<sup>63</sup>-1 </center> |
|- | |- | ||
− | | | + | | <center>NUMERIC</center> |
− | | | + | | <center>number</center> |
− | | No limit | + | | <center>No limit</center> |
− | | <center> | + | | <center>yes</center> |
| <center>(Max Scale, Max Precision )</center> | | <center>(Max Scale, Max Precision )</center> | ||
<center>Max Scale = unlimited</center> | <center>Max Scale = unlimited</center> | ||
− | <center>Max Precision = e<sup>+/-2<sup>31</sup></sup></center> | + | <center>Max Precision = e<sup>(+/-)2<sup>31</sup></sup></center> |
|- | |- | ||
− | | | + | | <center>DECIMAL</center> |
− | | | + | | <center>decimal</center> |
− | | | + | | <center>no limit</center> |
− | | <center> | + | | <center>yes</center> |
| <center>(Max Scale, Max Precision )</center> | | <center>(Max Scale, Max Precision )</center> | ||
<center>Max Scale = unlimited</center> | <center>Max Scale = unlimited</center> | ||
− | <center>Max Precision = e<sup>+/-2<sup>31</sup></sup></center> | + | <center>Max Precision = e<sup>(+/-)2<sup>31</sup></sup></center> |
|- | |- | ||
− | | | + | | <center>REAL</center> |
− | | | + | | <center>real</center> |
− | | 4 | + | | <center>4</center> |
− | | <center> | + | | <center>yes</center> |
− | | <center> | + | | <center>2<sup>-1074</sup> to (2-2<sup>-52</sup>)* 2<sup>1023</sup></center> |
|- | |- | ||
− | | | + | | <center>FLOAT</center> |
− | | | + | | <center>float</center> |
− | | 4 | + | | <center>4</center> |
− | | <center> | + | | <center>yes</center> |
− | | <center> | + | | <center>2<sup>-1074</sup> to (2-2<sup>-52</sup>)* 2<sup>1023</sup></center> |
|- | |- | ||
− | | | + | | <center>DOUBLE</center> |
− | | | + | | <center>double</center> |
− | | 4 | + | | <center>4</center> |
− | | <center> | + | | <center>yes</center> |
− | | <center> | + | | <center>2<sup>-1074</sup> to (2-2<sup>-52</sup>)* 2<sup>1023</sup></center> |
|} | |} | ||
− | (2-2<sup>-52</sup>)* 2<sup>1023</sup> | + | 2<sup>-1074</sup> to (2-2<sup>-52</sup>)* 2<sup>1023</sup> could also be stated as 5e<sup>-324</sup> to 1.7976931348623157e<sup>+308</sup> |
− | + | ||
=== Alphanumeric Types === | === Alphanumeric Types === |
Revision as of 19:35, 2 January 2011
Template:Documentation/NeedsRework
Contents
Variable Types for Embedded Base Database
Numeric Types
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2-1074 to (2-2-52)* 21023 could also be stated as 5e-324 to 1.7976931348623157e+308
Alphanumeric Types
|
|
|
|
Memo | Long Var Char | 2GB for 32 bit OS | Stores up to the max length or number indicated by user. It accepts any UTF 8 Character |
Text (fix) | Char | 2GB for 32 bit OS | Stores exactly the length specified by user. Pads with trailing spaces for shorter strings. Accepts any UTF 8 Character. |
Text | Var Char | 2GB for 32 bit OS | Stores up to the specified length. No padding (Same as long var char) |
Text | Var Char Ignore Case | 2GB for 32 bit OS | Stores up the the specified length. Comparisons are not case sensitive but stores capitals as you type them. |
Binary Types
|
|
|
|
Image | Long Var Binary | 2GB for 32 bit OS | Stores any array of bytes (images, sounds, etc). No validation required. |
Binary | Var Binary | 2GB for 32 bit OS | Stores any array of bytes. No validation required. |
Binary (fix) | Binary | 2GB for 32 bit OS | Stores any array of bytes. No validation required. |
Date time
Name | Description | Format |
Date | Stores month, day and year information | 1/1/99 to 1/1/9999 |
Time | Stores hour, minute and second info | Seconds since 1/1/1970 |
Timestamp | Stores date and time information |
Other Variable types
|
Description |
Other | Stores serialized Java objects – user application must supply serialization routines |
Object | Same |