Difference between revisions of "Base/Data Types"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Numeric Types)
(→‎Alphanumeric Types)
Line 101: Line 101:
  
 
|-
 
|-
−
| Memo
+
| <center>LONGVARCHAR</center>
−
| Long Var Char
+
| <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
  
 
|-
 
|-
−
| Text (fix)
+
| <center>CHAR</center>
−
| Char
+
| <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.
  
 
|-
 
|-
−
| Text
+
| <center>VARCHAR</center>
−
| Var Char
+
| <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)
  
 
|-
 
|-
−
| Text
+
| <center>VARCHAR_IGNORECASE</center>
−
| Var Char Ignore Case
+
| <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

Variable Types for Embedded Base Database

Numeric Types

Name
Data type
No. of Bytes
Signed
Range
BOOLEAN
yes / no
1
----
0,1
TINYINT
tiny integer
1
no
0 to 255
SMALLINT
small integer
2
yes
-215 to 215-1
INTEGER
integer
4
yes
-231 to 231-1
BIGINT
big integer
8
yes
-263 to 263-1
NUMERIC
number
no limit
yes
(Max Scale, Max Precision )
Max Scale = unlimited
Max Precision = e(+/-)231
DECIMAL
decimal
no limit
yes
(Max Scale, Max Precision )
Max Scale = unlimited
Max Precision = e(+/-)231
REAL
real
4
yes
2-1074 to (2-2-52)* 21023
FLOAT
float
4
yes
2-1074 to (2-2-52)* 21023
DOUBLE
double
4
yes
2-1074 to (2-2-52)* 21023

2-1074 to (2-2-52)* 21023 could also be stated as 5e-324 to 1.7976931348623157e+308

Alphanumeric Types

Name
Data type
Max length
Description
LONGVARCHAR
memo
 2GB for 32 bit OS Stores up to the max length or number indicated by user. It accepts any UTF 8 Character
CHAR
text (fix)
 2GB for 32 bit OS Stores exactly the length specified by user. Pads with trailing spaces for shorter strings. Accepts any UTF 8 Character.
VARCHAR
text
 2GB for 32 bit OS Stores up to the specified length. No padding (Same as long var char)
VARCHAR_IGNORECASE
text
 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

Name
Data type
Max length
Description
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

Name
 Description
Other Stores serialized Java objects – user application must supply serialization routines
Object Same
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Base/Data_Types&oldid=191209"
Personal tools