Base/Data Types

Variable Types for Embedded Base Database

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	2^15-1 to -2¹⁵
Integer	Integer	4 Bytes	Yes	2^31-1 to -2³¹
Bigint	Big integer	8 Bytes	Yes	2^63-1 to -2⁶³
Numeric	Number	No limit	Yes	(Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e^+/-2³¹
Decimal	Decimal	No limit	Yes	(Max Scale, Max Precision ) Max Scale = unlimited Max Precision = e^+/-2³¹
Real	Real	4 Bytes	Yes	(2-2^-52)* 2¹⁰²³ to 2^-1074
Float	Float	4 Bytes	Yes	(2-2^-52)* 2¹⁰²³ to 2^-1074
Double	Double	4 Bytes	Yes	(2-2^-52)* 2¹⁰²³ to 2^-1074

(2-2^-52)* 2¹⁰²³ to 2^-1074 could also be stated as 1.7976931348623157e+308 to 5e-324

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.

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.

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

Name	Description
Other	Stores serialized Java objects â€“ user application must supply serialization routines
Object	Same