TurboDB Engine Documentation
Column Data Types
Previous  Top  Next


These are the column types supported by TurboDB and Turbo SQL:

Turbo SQL Column Type
TurboDB Column Type
Description
AUTOINC
AutoInc
Integer field which receives a unique number from the database engine
CHAR(N)
String
Ansi string up to N characters long. 1 <= N <= 255
WCHAR(N)
WideString
Unicode string up N characters long. The actual field size in bytes is twice the number of characters. 1 <= N <= 127
BYTE
Byte
An integral number between 0 and 255
SMALLINT
SmallInt
An integral number between -32.768 and +32.767
INTEGER
Integer
An integral number between -2.147.483.648 and +2.147.483.647
BIGINT
BitInt
An integral number between -2^63 and +2^63-1
DOUBLE PRECISION
Float
Floating point number between 5.0 x 10^-324 and 1.7 x 10^308 with 15 significant digits
BOOLEAN
Boolean
Possible values are TRUE and FALSE
TIME
Time
Time of day containing hours and minutes
DATE
Date
Date value between 1/1/1 and 12/31/9999
TIMESTAMP
DateTime
Combined date and time with a precision of milliseconds between 1/1/1 12:00:00.000 am and 12/31/9999 11:59:59.999 pm
ENUM("value1", "value2", ..)
Enum
One of the enumeration values given. The values must be valid identifiers up to 40 characters in length. The sum of all values must not exceed 255 characters. There can be up to 16 values.
VARCHAR(N)
String
Treated like CHAR(N) in the current version
VARWCHAR(N)
WideString
Treated like WCHAR(N) in the current version
LONGVARCHAR
Memo
Ansi string of variable length up to 2 G characters
LONGVARWCHAR
WideMemo
Unicode string of variable length up to 2 G characters
LONGVARBINARY
Blob
Bit-stream containing arbitrary data up 2 GB
LINK("table_reference")
Link
Holds value of AutoInc column of another table and such builds a one-to-many relationship
RELATION("table_reference")
Relation
Holds any number of AutoInc values of another table. Used to create a many-to-many relationship