$ cubrid createdb tmp en_US Creating database with 512.0M size using locale en_US. The total amount of disk space needed is 1.5G. CUBRID 9.2 $ csql -u dba -S tmp CUBRID SQL Interpreter Type `;help' for help messages. csql> select charset(''); === <Result of SELECT Command in Line 1> === charset('') ====================== 'iso88591' 1 rows selected. (0.011982 sec) Committed. 1 command(s) successfully processed. csql> create table tmp(col1 int auto_increment, col2 varchar(5) COLLATE utf8_bin) COLLATE utf8_ko_cs; Execute OK. (0.001303 sec) Committed. 1 command(s) successfully processed. |
예1] csql> insert into tmp(col2) values('가'); 1 row affected. (0.009916 sec) Committed. 1 command(s) successfully processed. csql> select * from tmp; === <Result of SELECT Command in Line 1> === col1 col2 =================================== 1 'ê°?' 1 rows selected. (0.019385 sec) Committed. 1 command(s) successfully processed. |
예2] csql> insert into tmp(col2) values(_utf8'나'); 1 row affected. (0.000220 sec) Committed. 1 command(s) successfully processed. csql> select * from tmp; === <Result of SELECT Command in Line 1> === col1 col2 =================================== 1 'ê°?' 2 '나' 2 rows selected. (0.011894 sec) Committed. 1 command(s) successfully processed.
|
예3] csql> set names utf8; Execute OK. (0.000025 sec) Committed. 1 command(s) successfully processed. csql> insert into tmp(col2) values('다'); 1 row affected. (0.000282 sec) Committed. 1 command(s) successfully processed. csql> select * from tmp; === <Result of SELECT Command in Line 1> === col1 col2 =================================== 1 'ê°?' 2 '나' 3 '다' 3 rows selected. (0.011805 sec) Committed. 1 command(s) successfully processed. |