"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/string_data_types.rst" (6 May 2012, 1211 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

String Data Types

The string types in Drizzle are explained in the following groupings:

VARCHAR and VARBINARY

A VARCHAR or VARBINARY type is used to store variable length data. Indexes on these types are by default the full length of the data stored. The only difference between the two types is the COLLATION which is used. VARBINARY uses a binary collation for all index usage.

Note

CHAR and BINARY types are implicitly changed to VARCHAR and VARBINARY respectively.

TEXT and BLOB

A TEXT or BLOB type is used to store data which is over XXX in size. Indexes on these types must specify the number of character or bytes which should be used. The only difference between the two types is the COLLATION which is used. A BLOB uses a binary collation for all index usage.

ENUM

Enum (enumerated) types are static lists of strings that are defined on table creation. They can be used to represent a collection of string types that are sorted based on the order that they are created.

UTF-8

Drizzle stores its string data in an UTF-8 format, and does not support a multitude of language encodings and collations.