Base/Data Types

From OpenOffice.org Wiki

Contents 1 Variable Types for Embedded Base Database 1.1 Numeric Types 1.2 Alphanumeric Types 1.3 Binary Types 1.4 Date time 1.5 Other Variable types

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)* 2¹⁰²³ 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