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 - 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
|
Memo
|
Long Var Char
|
2GB 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
|