Difference between revisions of "Base/Data Types"
From Apache OpenOffice Wiki
< Base
DrewJensen (Talk | contribs) (→check me Categories) |
(→Alphanumeric Types) |
||
Line 98: | Line 98: | ||
| <center>'''Name'''</center> | | <center>'''Name'''</center> | ||
| <center>'''Data type'''</center> | | <center>'''Data type'''</center> | ||
− | | <center>'''Max length'''</center> | + | | <center>'''Max length '''</center> |
| <center>'''Description'''</center> | | <center>'''Description'''</center> | ||
Line 104: | Line 104: | ||
| Memo | | Memo | ||
| Long Var Char | | 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 | | Stores up to the max length or number indicated by user. It accepts any UTF 8 Character | ||
Line 116: | Line 116: | ||
| Text | | Text | ||
| Var Char | | Var Char | ||
− | | 2GB for 32 bit OS | + | | 2GB for 32 bit OS |
| Stores up to the specified length. No padding (Same as long var char) | | Stores up to the specified length. No padding (Same as long var char) | ||
Line 126: | Line 126: | ||
|} | |} | ||
+ | |||
=== Binary Types === | === Binary Types === | ||
Revision as of 03:42, 14 October 2008
Template:Documentation/NeedsRework
Contents
Variable Types for Embedded Base Database
Numeric Types
|
|
|
|
|
Boolean | yes/no | I Byte | |
|
Tinyint | Tiny Integer | 1 Byte | |
|
Smallint | Small Integer | 2 Bytes | |
|
Integer | Integer | 4 Bytes | |
|
Bigint | Big integer | 8 Bytes | |
|
Numeric | Number | No limit | |
|
Decimal | Decimal | No limit | |
|
Real | Real | 4 Bytes | |
|
Float | Float | 4 Bytes | |
|
Double | Double | 4 Bytes | |
|
(2-2-52)* 21023 to 2-1074 </center> could also be stated as 1.7976931348623157e+308 to 5e-324
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 |