Location:
d32dbms.h
Link against:
TDbColType
Support
Supported from 5.0
Description
Represents every supported column type.
EDbColBit |
The column stores a single bit.
Representation range: 0 to 1
Storage: 1 bit
Auto-increment: Yes
Index key: Yes |
EDbColUint8 |
The column stores an 8-bit unsigned integer.
Representation range: 0 to 2^8-1
Storage: 1 byte
Auto-increment: Yes
Index key: Yes |
EDbColUint16 |
The column stores a 16-bit unsigned integer.Representation range: 0 to 2^16-1
Storage: 2 bytes
Auto-increment: Yes
Index key: Yes |
EDbColUint32 |
The column stores a 32-bit unsigned integer.Representation range: 0 to 2^32-1
Storage: 4 bytes
Auto-increment: Yes
Index key: Yes |
EDbColInt8 |
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 |
EDbColInt16 |
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 |
EDbColInt32 |
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 |
EDbColInt64 |
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 |
EDbColReal32 |
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 |
EDbColReal64 |
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 |
EDbColDateTime |
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 |
EDbColText8 |
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 |
EDbColText16 |
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 |
EDbColBinary |
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 |
EDbColLongText8 |
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 |
EDbColLongText16 |
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 |
EDbColLongBinary |
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 |
EDbColText |
This is equivalent to EDbColText8 if the build is narrow,
and EDbColText16 if the build is narrow or
Unicode. |
EDbColLongText |
This is equivalent to EDbColLongText8 if the build is
narrow, and EDbColLongText16 if the build is
Unicode. |
|