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 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
|