Difference between revisions of "Base/Data Types"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎1st draft)
 
(→‎check me Categories)
Line 1: Line 1:
 +
{{Documentation/NeedsRework}}
 +
 
== Variable Types for Embedded Base Database ==
 
== Variable Types for Embedded Base Database ==
 
=== Numeric Types ===
 
=== Numeric Types ===
Line 189: Line 191:
  
 
|}
 
|}
 +
 +
 +
[[Category:Database]]
 +
[[Category:Base Documentation]]

Revision as of 16:21, 15 October 2007

Template:Documentation/NeedsRework

Variable Types for Embedded Base Database

Numeric Types

Name
Data type
No. of Bytes
Signed
Range
Boolean yes/no I Byte
----
0 - 1
Tinyint Tiny Integer 1 Byte
No
0 - 255
Smallint Small Integer 2 Bytes
Yes
215-1 to -215
Integer Integer 4 Bytes
Yes
231-1 to -231
Bigint Big integer 8 Bytes
Yes
263-1 to -263
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 Bytes
Yes
(2-2-52)* 21023 to 2-1074
Float Float 4 Bytes
Yes
(2-2-52)* 21023 to 2-1074
Double Double 4 Bytes
Yes
(2-2-52)* 21023 to 2-1074

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


Alphanumeric Types

Name
Data type
Max length
Description
Memo Long Var Char 2 GB 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

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=50600"
Personal tools