CUBRID 문자셋(characterset) 확인하기

CUBRID characterset 확인

---

CUBRID 8.x 버전까지느 클라이언트 characterset에 의해 데이터가 입력 됬습니다.

9.x 버전 이후 부터는 DB characterset이 생겼으며, 9.x 이후 버전부터 characterset을 확인할 수 있습니다.

CUBRID 9.x SQL

csql> SELECT * FROM db_collation;

=== <Result of SELECT Command in Line 1> ===

      coll_id  coll_name             charset_name          is_builtin            has_expansions        contractions  uca_strength
=========================================================================================================================================
            0  'iso88591_bin'        'iso88591'            'Yes'                 'No'                             0  'Not applicable'
            1  'utf8_bin'            'utf8'                'Yes'                 'No'                             0  'Not applicable'
            2  'iso88591_en_cs'      'iso88591'            'Yes'                 'No'                             0  'Not applicable'
            3  'iso88591_en_ci'      'iso88591'            'Yes'                 'No'                             0  'Not applicable'
            4  'utf8_en_cs'          'utf8'                'Yes'                 'No'                             0  'Not applicable'
            5  'utf8_en_ci'          'utf8'                'Yes'                 'No'                             0  'Not applicable'
            6  'utf8_tr_cs'          'utf8'                'Yes'                 'No'                             0  'Not applicable'
            7  'utf8_ko_cs'          'utf8'                'Yes'                 'No'                             0  'Not applicable'
            8  'euckr_bin'           'euckr'               'Yes'                 'No'                             0  'Not applicable'
            
csql> SELECT * FROM db_root;

=== <Result of SELECT Command in Line 2> ===

  triggers                  charset  lang
=========================================================
  NULL                            5  'ko_KR'

db_root 결과의 charset 값이 db_collation과 대응 되는 것을 확인 합니다.

 

CUBRID 10.x SQL

csql> select * from db_collation;

=== <Result of SELECT Command in Line 1> ===

      coll_id  coll_name             charset_name          is_builtin            has_expansions        contractions  uca_strength        
=========================================================================================================================================
            0  'iso88591_bin'        'iso88591'            'Yes'                 'No'                             0  'Not applicable'    
            1  'utf8_bin'            'utf8'                'Yes'                 'No'                             0  'Not applicable'    
            2  'iso88591_en_cs'      'iso88591'            'Yes'                 'No'                             0  'Not applicable'    
            3  'iso88591_en_ci'      'iso88591'            'Yes'                 'No'                             0  'Not applicable'    
            4  'utf8_en_cs'          'utf8'                'Yes'                 'No'                             0  'Not applicable'    
            5  'utf8_en_ci'          'utf8'                'Yes'                 'No'                             0  'Not applicable'    
            6  'utf8_tr_cs'          'utf8'                'Yes'                 'No'                             0  'Not applicable'    
            7  'utf8_ko_cs'          'utf8'                'Yes'                 'No'                             0  'Not applicable'    
            8  'euckr_bin'           'euckr'               'Yes'                 'No'                             0  'Not applicable'    
            9  'binary'              'binary'              'Yes'                 'No'                             0  'Not applicable'
            
csql> select * from db_root;

=== <Result of SELECT Command in Line 1> ===

  triggers                  charset  lang                  timezone_checksum   
===============================================================================
  NULL                            5  'ko_KR'               '6c6bfa7d1ea390048a392519dd349888'

1 row selected. (0.005479 sec) Committed. (0.000257 sec) 

1 command(s) successfully processed.

db_root 결과의 charset 값이 db_collation과 대응 되는 것을 확인 합니다.

SELECT 
    A.charset_name AS charset,
    B.lang AS LANG
FROM
    db_charset A INNER JOIN db_root B ON A.charset_id = b.charset

---

---