TurboSQL Guide

TurboSQL Column Types

Previous  Top  Next

These are the column types supported by TurboSQL.

AUTOINC

Syntax

AUTOINC(indication)

TurboDB Column Type

AutoInc

Description

Integer field which receives a unique number from the database engine. Field values of link columns in dependent tables are displayed according to the indication, which is a string containing an index definition. (See "Automatic Linking".)

Example

AUTOINC('LastName, FirstName')

BIGINT

Syntax

BIGINT [NOT NULL]

TurboDB Column Type

BigInt

Description

An integral number between 2^63 and +2^631

Example

BIGINT DEFAULT 4000000000

BIT

Not supported in TurboSQL.

BOOLEAN

Syntax

BOOLEAN [NOT NULL]

TurboDB Column Type

Boolean

Description

Possible values are TRUE and FALSE

Example

BOOLEAN DEFAULT TRUE

BYTE

Syntax

BYTE [NOT NULL]

TurboDB Column Type

Byte

Description

An integral number between 0 and 255

Example

BYTE NOT NULL DEFAULT 18

CHAR

Syntax

CHAR(n) [NOT NULL]

TurboDB Column Type

String

Description

Ansi string up to N characters long. 1 <= n <= 32767

Example

CHAR(40)

CURRENCY

Not supported in TurboSQL, use DOUBLE PRECISION or BIGINT.

DATE

Syntax

DATE [NOT NULL]

TurboDB Column Type

Date

Description

Date value between 1/1/1 and 12/31/9999

Example

DATE

DECIMAL

Not supported in TurboSQL, use DOUBLE PRECISION.

DOUBLE PRECISION

Syntax

DOUBLE [PRECISION][(p)] [NOT NULL]

TurboDB Column Type

Float

Description

Floating point number from 5.0e-324 to 1.7 x 10e308 with a precision of 12 signification digits. p is the number of displayed digits after the decimal point. 0 <= p <= 12.

Example

DOUBLE(4) NOT NULL

ENUM

Syntax

ENUM(value1, value2, value3, ...) [NOT NULL]

TurboDB Column Type

Enum

Description

Column that holds one of the enumeration values given stored as a number internally. The values must be valid identifiers up to 40 characters in length. There can be up to 15 values.

Example

ENUM(Red, Blue, Green, Yellow)

FLOAT

Not supported in TurboSQL, use DOUBLE PRECISION.

GUID

Syntax

GUID [NOT NULL]

TurboDB Column Type

Guid

Description

A universally unique identifier 16 bytes in size.

Example

GUID DEFAULT '12345678-abcd-abcd-efef-010101010101'

INTEGER

Syntax

INTEGER [NOT NULL]

TurboDB Column Type

Integer

Description

An integral number between 2.147.483.648 and +2.147.483.647

Example

INTEGER NOT NULL

LINK

Syntax

LINK(table_reference) [NOT NULL]

TurboDB Column Type

Link

Description

Holds value of AutoInc column of another table and such builds a one-to-many relationship. Table_reference is the name of referenced table. (See "Automatic Linking".)

Example

LINK(PARENTTABLE)

LONGVARBINARY

Syntax

LONGVARBINARY [NOT NULL]

TurboDB Column Type

Blob

Description

Long bit-stream containing arbitrary data up 2 GB

Example

LONGVARBINARY

LONGVARCHAR

Syntax

LONGVARCHAR [NOT NULL]

TurboDB Column Type

Memo

Description

Long Ansi string of variable length up to 2 G characters

Example

LONGVARCHAR

LONGVARWCHAR

Syntax

LONGVARWCHAR [NOT NULL]

TurboDB Column Type

WideMemo

Description

Long Unicode string of variable length up to 2 G characters

Example

LONGVARWCHAR

MONEY

Not supported in TurboSQL, use DOUBLE PRECISION or BIGINT.

NUMERIC

Not supported in TurboSQL, use DOUBLE PRECISION.

RELATION

Syntax

RELATION(table_reference)

TurboDB Column Type

Relation

Description

Holds any number of AutoInc values of another table. Used to create a many-to-many relationship. (See "Automatic Linking".)

Compatibility

Feature is not supported in TurboDB Managed 1.x.

Example

RELATION(PARENTTABLE)

TIME

Syntax

TIME[(p)] [NOT NULL]

TurboDB Column Type

Time

Description

Time of day with a precision of p, where p = 2 means minutes, p = 3 means seconds and p = 4 means milliseconds, the default being 3. The precision is available only in table level 4 and above; it is always set to 2 in tables up to level 3.

Example

TIME(4) DEFAULT 8:32:12.002

TIMESTAMP

Syntax

TIMESTAMP [NOT NULL]

TurboDB Column Type

DateTime

Description

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

Examples

TIMESTAMP DEFAULT 23.12.1899_15:00:00
TIMESTAMP DEFAULT '5/15/2006 7:00:00'

VARCHAR

Syntax

VARCHAR(n) [NOT NULL]

TurboDB Column Type

String

Description

Same as CHAR

Example

VARCHAR(40)

VARWCHAR

Syntax

VARWCHAR(n) [NOT NULL]

TurboDB Column Type

WideString

Description

Same as WCHAR

Example

VARWCHAR(20) NOT NULL

SMALLINT

Syntax

SMALLINT [NOT NULL]

TurboDB Column Type

SmallInt

Description

An integral number between -32.768 and +32.767

Example

SMALLINT

WCHAR

Syntax

WCHAR(n) [NOT NULL]

TurboDB Column Type

WideString

Description

Unicode string up N characters long. The actual field size in bytes is twice the number of characters. 1 <= n <= 32767

Example

WCHAR(1000) DEFAULT '-'