Symbian
Symbian Developer Library

SYMBIAN OS V9.4

Feedback

[Index] [Previous] [Next]

#include <D32DBMS.H>

Typedef TDbName

typedef TBuf<KDbMaxName> TDbName;

Description

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:

[Top]

Typedef TDbNameC

typedef TBufC<KDbMaxName> TDbNameC;

Description

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:

[Top]

Typedef TDbColName

typedef TBuf<KDbMaxColName> TDbColName;

Description

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.

[Top]

Typedef TDbColNameC

typedef TBufC<KDbMaxColName> TDbColNameC;

Description

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:

[Top]

Typedef TDbColNo

typedef TInt TDbColNo;

Description

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.

[Top]

Typedef CDbTableNames

typedef CDbNames CDbTableNames;

Description

[Top]

Typedef CDbIndexNames

typedef CDbNames CDbIndexNames;

Description

[Top]

Typedef CDbDatabaseNames

typedef CDbNames CDbDatabaseNames;

Description

[Top]

Typedef TDbStringC

typedef TBufC<KDbMaxStrLen> TDbStringC;

Description

Represents a generic read-only DBMS string. It maps to a non-modifiable buffer descriptor with maximum size KDbMaxStrLen.

See also:

[Top]

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^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 Unicode.

EDbColLongText

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

[Top]

Enum TDbTextComparison

TDbTextComparison

Description

Represents different ways of comparing Text and LongText columns.

This affects the ordering of indexes (see CDbKeyCDbKey), the evaluation of SQL queries and matching row constraints (see TDbQueryTDbQuery).

EDbCompareNormal

Use standard text comparison and ordering.

EDbCompareFolded

Use folded text for comparison and ordering.

EDbCompareCollated

Use collation for comparison and ordering.

D32DBMS.H Global variables

[Top]

KDbMaxName

const TInt KDbMaxName=0x40;

Description

The maximum length for a DBMS name: 64 characters.

[Top]

KDbMaxColName

const TInt KDbMaxColName=KDbMaxName;

Description

The maximum length for a DBMS column name: 64 characters.

[Top]

KDbNullColNo

const TDbColNo KDbNullColNo=0;

Description

Indicates that a specified column does not exist.

[Top]

KDbUndefinedCount

const TInt KDbUndefinedCount=-1;

Description

A value returned by RDbRowSet::Count() when the number of rows cannot be determined.

See also:

[Top]

KDbUndefinedLength

const TInt KDbUndefinedLength=-1;

Description

The length of a column is undefined.

[Top]

KDbDefaultTextColLength

const TInt KDbDefaultTextColLength=50;

Description

The default text column length. This is equal to 50.

[Top]

KDbUnlimitedWindow

const TDbWindow KDbUnlimitedWindow=TDbWindow(TDbWindow::EUnlimited);

Description

[Top]

KDbMaxStrLen

const TInt KDbMaxStrLen=256;

Description

The maximum length for a generic DBMS string, which might be transferred from DBMS server to the DBMS client using IPC.

[Previous] [Top] [Next]