Enum TDbColType

The column stores a single bit.

Representation range: 0 to 1

Storage: 1 bit

Auto-increment: Yes

Index key: Yes

The column stores an 8-bit unsigned integer.

Representation range: 0 to 2^8-1

Storage: 1 byte

Auto-increment: Yes

Index key: Yes

The column stores a 16-bit unsigned integer.

Representation range: 0 to 2^16-1

Storage: 2 bytes

Auto-increment: Yes

Index key: Yes

The column stores a 32-bit unsigned integer.

Representation range: 0 to 2^32-1

Storage: 4 bytes

Auto-increment: Yes

Index key: Yes

The column stores an 8-bit signed integer.

Representation range: -2^7 to 2^7 - 1

Storage: 1 byte

Auto-increment: Yes

Index key: Yes

The column stores a 16-bit signed integer.

Representation range: -2^15 to 2^15 - 1

Storage: 2 bytes

Auto-increment: Yes

Index key: Yes

The column stores a 32-bit signed integer.

Representation range: -2^31 to 2^31 - 1

Storage: 4 bytes

Auto-increment: Yes

Index key: Yes

The column stores a 64-bit signed integer.

Representation range: -2^63 to 2^63 - 1

Storage: 8 bytes

Auto-increment: No

Index key: Yes

The column stores a 32-bit floating point value.

Representation range: 1.4 X 10^-45 to 3.40282 X 10^38

Storage: 4 bytes

Auto-increment: No

Index key: Yes

The column stores a 64-bit floating point value.

Representation range: 2.2 X 10^-308 to 1.79769 X 10^308

Storage: 8 bytes

Auto-increment: No

Index key: Yes

The column stores a date/time value.

Representation range: 1/1/0 to 31/12/9999

Storage: 8 bytes

Auto-increment: No

Index key: Yes

The column stores a (short) variable length of non-Unicode text data.

Representation range: 0 to 255 characters

Storage: 0 to 256 bytes

Auto-increment: No

Index key: Yes

The column stores a (short) variable length of Unicode text data.

Representation range: 0 to 255 characters

Storage: 0 to 511 bytes

Auto-increment: No

Index key: Yes

The column stores a (short) variable length of untyped data.

Representation range: 0 to 255 bytes

Storage: 0 to 256 bytes

Auto-increment: No

Index key: No

The column stores a potentially large amount of non-Unicode text data.

Representation range: 0 to 2^31 characters

Storage: 0 to 2 Gbytes

Auto-increment: No

Index key: Truncated

The column stores a potentially large amount of Unicode text data.

Representation range: 0 to 2^30 characters

Storage: 0 to 2 Gbytes

Auto-increment: No

Index key: Truncated

The column stores a potentially large amount of untyped data.

Representation range: 0 to 2^31 bytes

Storage: 0 to 2 Gbytes

Auto-increment: No

Index key: No

This is equivalent to EDbColText8 if the build is narrow, and EDbColText16 if the build is narrow or Unicode.

This is equivalent to EDbColLongText8 if the build is narrow, and EDbColLongText16 if the build is Unicode.