Base/Data Types

This article should be checked for accuracy and conformity to style.

Variable Types for Embedded Base Database

Name	Data type	No. of Bytes	Signed	Range
BOOLEAN	boolean	1	no	0 or 1
TINYINT	integer	1	no	0 to 255
SMALLINT	integer	2	yes	-2¹⁵ to 2¹⁵-1
INTEGER	integer	4	yes	-2³¹ to 2³¹-1
BIGINT	integer	8	yes	-2⁶³ to 2⁶³-1
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	yes	2^-1074 to (2-2^-52)* 2¹⁰²³
FLOAT	float	4	yes	2^-1074 to (2-2^-52)* 2¹⁰²³
DOUBLE	double	4	yes	2^-1074 to (2-2^-52)* 2¹⁰²³

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

Name	Data type	Max length	Description
LONGVARCHAR	text	2GB for 32 bit OS	Stores up to the max number of characters indicated by user. It accepts any UTF 8 character.
CHAR	text(fix)	2GB for 32 bit OS	Stores exactly the number of characters specified by user. Pads with trailing spaces for shorter strings. Accepts any UTF 8 character.
VARCHAR	text	2GB for 32 bit OS	Stores up to the specified number of characters. No padding (Same as long var char).
VARCHAR_IGNORECASE	text	2GB for 32 bit OS	Stores up to the specified number of characters. Comparisons are not case-sensitive, but stores capitals as you type them.

Name	Data type	Max length	Description
LONGVARBINARY	image	2GB for 32 bit OS	Stores any array of bytes (images, sounds, etc). No validation required.
BINARY	binary (fix)	2GB for 32 bit OS	Stores any array of bytes. No validation required.
VARBINARY	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