애러메세지: mysql_err : 1267 : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation 'like'
#] mysql -u root -p mysql> use realDB; Database changed
mysql> select * from saju_hanja where hj_hanja like '가';; Empty set (0.00 sec)
mysql> select hj_hangul from saju_hanja limit 5; +-----------+ | hj_hangul | +-----------+ | ? | | ? | | ? | | ? | | ? | +-----------+ 5 rows in set (0.00 sec)
mysql> status -------------- mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
Connection id: 1332 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.0.37-log Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: euckr Db characterset: euckr Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 1 hour 54 min 38 sec
Threads: 1 Questions: 14097 Slow queries: 85 Opens: 1264 Flush tables: 1 Open tables: 64 Queries per second avg: 2.050 --------------
Server 와 Db characterset: euckr 인데 Client 와 Conn. characterset : latin1 으로 되어있는 경우입니다.
작업 중인 PHP소스파일의 시작부분이나 DB 연결부분에 다음의 한줄을 추가해 줍니다. mysql_query("SET CHARACTER SET euckr");
|