Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 9.0.0 | 

DB_COLLATION

The information on collation.

Attribute Name

Data Type

Description

coll_id

INTEGER

Collation ID

coll_name

VARCHAR(255)

Collation name

charset_name

VARCHAR(256)

Charset name

is_builtin

VARCHAR(3)

Built-in or not while installing the product

has_expansions

VARCHAR(3)

Having expansion or not

contractions

INTEGER

Whether to include abbreviation

uca_strength

VARCHAR(255)

Weight strength
(NOT APPLICABLE, PRIMARY, SECONDARY, TERTIARY, QUATERNARY, IDENTITY, UNKNOWN)

Definition

CREATE VCLASS db_collation (coll_id, coll_name, charset_name, is_builtin, has_expansions, contractions)

AS

 

SELECT c.coll_id, c.coll_name,

CASE c.charset_id

    WHEN 3 THEN 'ISO8859-1'

    WHEN 5 THEN 'UTF-8'

    WHEN 4 THEN 'KSC-EUC'  

    WHEN 0 THEN 'ASCII'  

    WHEN 1 THEN 'RAW-BITS'  

    WHEN 2 THEN 'RAW-BYTES'  

    WHEN -1 THEN 'NONE'  

ELSE 'OTHER' END,

CASE c.built_in  

    WHEN 0 THEN 'NO'  

    WHEN 1 THEN 'YES'  

ELSE 'ERROR' END,

CASE c.expansions  

    WHEN 0 THEN 'NO'  

    WHEN 1 THEN 'YES'  

ELSE 'ERROR' END, c.contractions,

CASE c.uca_strength  

    WHEN 0 THEN 'NOT APPLICABLE'  

    WHEN 1 THEN 'PRIMARY'  

    WHEN 2 THEN 'SECONDARY'  

    WHEN 3 THEN 'TERTIARY'

    WHEN 4 THEN 'QUATERNARY'  

    WHEN 5 THEN 'IDENTITY'  

ELSE 'UNKNOWN' END

FROM _db_collation c ORDER BY c.coll_id;