DB_COLLATION

콜레이션에 대한 정보이다.

정의

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;