Forest index Gibson Digital Enterprises

A general description of Forest-SQL 1.0 Data Types:

Table Ref	check level	SQL Ref	Description
ch	1	CHAR	Character String. A string with a maximum length of 255 characters.
vc	1	VARCHAR	Variable Character String. A string with a maximum length of 255 characters.
tt	1	TINYTEXT	Tiny Text. A string with a maximum length of 255 characters.
tx	1	TEXT	Text. A string with a maximum length of 65535 characters.
ti	2	TINYINT	-128 to 127
pi	2	POSINT	Positive Integer. 0 to 99999
in	2	INT	Integer. -2147483648 to 2147483647
fl	2	FLOAT	A small number with a floating decimal point.
do	2	DOUBLE	A large number with a floating decimal point.
pd	2	POSDOUBLE	A large positive number with a floating decimal point.
da	3	DATE	YYYY-MM-DD.
tm	3	TIME	HH:MM:SS.