Difference between revisions of "Base/Data Types"
From Apache OpenOffice Wiki
< Base
(→Numeric Types) |
(→Alphanumeric Types) |
||
Line 101: | Line 101: | ||
|- | |- | ||
− | | | + | | <center>LONGVARCHAR</center> |
− | | | + | | <center>memo</center> |
| 2GB for 32 bit OS | | 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 | ||
|- | |- | ||
− | | | + | | <center>CHAR</center> |
− | + | | <center>text (fix)</center> | |
| 2GB for 32 bit OS | | 2GB for 32 bit OS | ||
| Stores exactly the length specified by user. Pads with trailing spaces for shorter strings. Accepts any UTF 8 Character. | | Stores exactly the length specified by user. Pads with trailing spaces for shorter strings. Accepts any UTF 8 Character. | ||
|- | |- | ||
− | | | + | | <center>VARCHAR</center> |
− | | | + | | <center>text</center> |
| 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) | ||
|- | |- | ||
− | | | + | | <center>VARCHAR_IGNORECASE</center> |
− | | | + | | <center>text</center> |
| 2GB for 32 bit OS | | 2GB for 32 bit OS | ||
| Stores up the the specified length. Comparisons are not case sensitive but stores capitals as you type them. | | Stores up the the specified length. Comparisons are not case sensitive but stores capitals as you type them. |
Revision as of 17:57, 3 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
|
|
|
|
|
|
2GB for 32 bit OS | Stores up to the max length or number indicated by user. It accepts any UTF 8 Character |
|
|
2GB for 32 bit OS | Stores exactly the length specified by user. Pads with trailing spaces for shorter strings. Accepts any UTF 8 Character. |
|
|
2GB for 32 bit OS | Stores up to the specified length. No padding (Same as long var char) |
|
|
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 |