typedef TBuf< KDbMaxName > | TDbName |
Represents a writable DBMS name. It maps to a modifiable buffer descriptor with maximum size KDbMaxName.
Notes:
A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the _ (underscore) character may be used. DBMS names are also limited to 64 characters in length.
Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named column_one and Column_ONE are considered to have the same name.
See also: TBuf
typedef TBufC< KDbMaxName > | TDbNameC |
Represents a non-writeable DBMS name. It maps to a non modifiable buffer descriptor with maximum size KDbMaxName.
Notes:
A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the _ (underscore) character may be used. DBMS names are also limited to 64 characters in length.
Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named column_one and Column_ONE are considered to have the same name.
See also: TBufC
typedef TBuf< KDbMaxColName > | TDbColName |
Represents a writable DBMS column name. It maps to a modifiable buffer descriptor with maximum size KDbMaxColName.
Notes:
A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the _ (underscore) character may be used. DBMS names are also limited to 64 characters in length.
Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named column_one and Column_ONE are considered to have the same name.
typedef TBufC< KDbMaxColName > | TDbColNameC |
Represents a non-writable DBMS column name. It maps to a non-modifiable buffer descriptor with maximum size KDbMaxColName.
Notes:
A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the _ (underscore) character may be used. DBMS names are also limited to 64 characters in length.
Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named column_one and Column_ONE are considered to have the same name.
See also: TBufC
typedef TInt | TDbColNo |
Specifies when DBMS objects require a column ordinal to identify a column in a column set or in a rowset.
Note that KDbNullColNo is a special value of TDbColNo used to indicate that no such column exists.
const TInt | KDbUndefinedCount |
A value returned by RDbRowSet::Count() when the number of rows cannot be determined.
See also: RDbRowSet
const TInt | KDbDefaultTextColLength |
The default text column length. This is equal to 50.
Represents every supported column type.
Enumerator | Value | Description |
---|---|---|
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^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 | EDbColText16 |
This is equivalent to EDbColText8 if the build is narrow, and EDbColText16 if the build is Unicode. |
EDbColLongText | EDbColLongText16 |
This is equivalent to EDbColLongText8 if the build is narrow, and EDbColLongText16 if the build is Unicode. |
Represents different ways of comparing Text and LongText columns.
This affects the ordering of indexes (see CDbKey), the evaluation of SQL queries and matching row constraints (see TDbQuery).
Enumerator | Value | Description |
---|---|---|
EDbCompareNormal |
Use standard text comparison and ordering. | |
EDbCompareFolded |
Use folded text for comparison and ordering. | |
EDbCompareCollated |
Use collation for comparison and ordering. |
typedef CDbNames | CDbTableNames |
typedef CDbNames | CDbIndexNames |
typedef CDbNames | CDbDatabaseNames |
const TInt | KDbMaxStrLen |
The maximum length for a generic DBMS string, which might be transferred from DBMS server to the DBMS client using IPC.
typedef TBufC< KDbMaxStrLen > | TDbStringC |
Represents a generic read-only DBMS string. It maps to a non-modifiable buffer descriptor with maximum size KDbMaxStrLen.
See also: TBufC