SDK中Symbian DBMS 表列类型

» Symbian OS v9.2 » Symbian OS reference » C++ component reference » Syslibs DBMS » TDbColType

Location: D32DBMS.H

Enum TDbColType

TDbColType

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 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 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 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 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 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 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 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 256 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 256 characters Storage: 0 to 512 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^30 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^31 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 Unicode. EDbColLongText This is equivalent to EDbColLongText8 if the build is narrow, and EDbColLongText16 if the build is Unicode.

 

摘自：Symbian S60 3rd Edition SDK (Supporting Feature Pack 1).