Difference between revisions of "Base/Data Types"
From Apache OpenOffice Wiki
< Base
(→Numeric Types) |
m (→Alphanumeric Types) |
||
(10 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | {{ | + | {{NeedsRework|EN}} |
== Variable Types for Embedded Base Database == | == Variable Types for Embedded Base Database == | ||
Line 13: | Line 13: | ||
|- | |- | ||
| <center>BOOLEAN</center> | | <center>BOOLEAN</center> | ||
− | | <center> | + | | <center>boolean</center> |
| <center>1</center> | | <center>1</center> | ||
− | | <center> | + | | <center>no</center> |
− | | <center>0 | + | | <center>0 or 1</center> |
|- | |- | ||
| <center>TINYINT</center> | | <center>TINYINT</center> | ||
− | | <center> | + | | <center>integer</center> |
| <center>1</center> | | <center>1</center> | ||
| <center>no</center> | | <center>no</center> | ||
− | | <center>0 | + | | <center>0 to 255</center> |
|- | |- | ||
| <center>SMALLINT</center> | | <center>SMALLINT</center> | ||
− | | <center> | + | | <center>integer</center> |
| <center>2</center> | | <center>2</center> | ||
| <center>yes</center> | | <center>yes</center> | ||
Line 41: | Line 41: | ||
|- | |- | ||
| <center>BIGINT</center> | | <center>BIGINT</center> | ||
− | | <center> | + | | <center>integer</center> |
| <center>8</center> | | <center>8</center> | ||
| <center>yes</center> | | <center>yes</center> | ||
Line 49: | Line 49: | ||
| <center>NUMERIC</center> | | <center>NUMERIC</center> | ||
| <center>number</center> | | <center>number</center> | ||
− | | <center> | + | | <center>no limit</center> |
| <center>yes</center> | | <center>yes</center> | ||
| <center>(Max Scale, Max Precision )</center> | | <center>(Max Scale, Max Precision )</center> | ||
Line 101: | Line 101: | ||
|- | |- | ||
− | | | + | | <center>LONGVARCHAR</center> |
− | | | + | | <center>text</center> |
| 2GB for 32 bit OS | | 2GB for 32 bit OS | ||
− | | Stores up to the max | + | | Stores up to the max number of characters 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 | + | | Stores exactly the number of characters 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 | + | | Stores up to the specified number of characters. 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 | + | | Stores up to the specified number of characters. Comparisons are not case-sensitive, but stores capitals as you type them. |
|} | |} | ||
Line 135: | Line 135: | ||
|- | |- | ||
− | | | + | | <center>LONGVARBINARY</center> |
− | | | + | | <center>image</center> |
| 2GB for 32 bit OS | | 2GB for 32 bit OS | ||
| Stores any array of bytes (images, sounds, etc). No validation required. | | Stores any array of bytes (images, sounds, etc). No validation required. | ||
|- | |- | ||
− | | | + | | <center>BINARY</center> |
− | | | + | | <center>binary (fix)</center> |
| 2GB for 32 bit OS | | 2GB for 32 bit OS | ||
| Stores any array of bytes. No validation required. | | Stores any array of bytes. No validation required. | ||
|- | |- | ||
− | | | + | | <center>VARBINARY</center> |
− | | | + | | <center>binary</center> |
| 2GB for 32 bit OS | | 2GB for 32 bit OS | ||
| Stores any array of bytes. No validation required. | | Stores any array of bytes. No validation required. | ||
|} | |} | ||
+ | |||
=== Date time === | === Date time === | ||
Line 184: | Line 185: | ||
|- | |- | ||
| Other | | Other | ||
− | | Stores serialized Java objects | + | | Stores serialized Java objects. User application must supply serialization routines. |
|- | |- |
Latest revision as of 11:44, 11 September 2022
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 number of characters indicated by user. It accepts any UTF 8 character. |
|
|
2GB for 32 bit OS | Stores exactly the number of characters 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 number of characters. No padding (Same as long var char). |
|
|
2GB for 32 bit OS | Stores up to the specified number of characters. Comparisons are not case-sensitive, but stores capitals as you type them. |
Binary Types
|
|
|
|
|
|
2GB for 32 bit OS | Stores any array of bytes (images, sounds, etc). No validation required. |
|
|
2GB for 32 bit OS | Stores any array of bytes. No validation required. |
|
|
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 |