|
디비의 문자셋 설정을 보면 아래와 같습니다.
mysql> show variables like 'c%';
+--------------------------+---------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------+
| character_set_client | euckr |
| character_set_connection | euckr |
| character_set_database | euckr |
| character_set_filesystem | binary |
| character_set_results | euckr |
| character_set_server | euckr |
| character_set_system | utf8 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
| collation_connection | euckr_korean_ci |
| collation_database | euckr_korean_ci |
| collation_server | euckr_korean_ci |
| completion_type | NO_CHAIN |
| concurrent_insert | AUTO |
| connect_timeout | 10 |
+--------------------------+---------------------------------------------------------+
14 rows in set (0.00 sec)
mysql> show create table apple;
+-------+-----------------------------------------------
-------------------------------------------------+
| Table | Create Table
|
+-------+-----------------------------------------------
-------------------------------------------------+
| apple | CREATE TABLE `apple` (
`no` int(11) NOT NULL AUTO_INCREMENT,
`memo` text,
PRIMARY KEY (`no`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=euckr |
+-------+-----------------------------------------------
-------------------------------------------------+
mysql> insert into apple (memo) values ('나는 고양이가 좋아요.私はポテトが美味しいですよ。i am programmer');
Query OK, 1 row affected (0.01 sec)
mysql> select * from apple;
+----+------------------------------------------------------------------+
| no | memo |
+----+------------------------------------------------------------------+
| 1 | 나는 고양이가 좋아요.私はポテトが美味しいですよ。i am programmer |
+----+------------------------------------------------------------------+
1 row in set (0.00 sec)
=======================================================================
위과 같은 euckr 테이블에 한글과 일어.영어를 같이 넣었는데 정상적으로 입력과 출력이 됩니다.
원래 utf8만 동시입력이 되고 euckr은 한글만 입.출력이 가능한 것이 아닌가요?
답변 부탁드립니다. |
