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
|