한글 깨짐 문제 제발 도와주세요. 정보
한글 깨짐 문제 제발 도와주세요.본문
환경
CentOs 4.4
Apache/2.0.52 (CentOS)
PHP Version 4.3.9
mysql 4.1.20
Apache/2.0.52 (CentOS)
PHP Version 4.3.9
mysql 4.1.20
euckr버전을 받아서, db생성하고, 설치완료후에
회원가입을 눌러보면, 한글이 깨져서 나옵니다. (db에서 불러오는 내용-첨부그림)
그래서, 신규가입 완료로 눌러보면, 데이터가 들어가지 않고,
아래의 에러가 납니다.
select count(*) as cnt from g4_point where mb_id = '1111' and po_rel_table = '@member' and po_rel_id = '1111' and po_rel_action = '회원가입'
1267 : Illegal mix of collations (euckr_korean_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
[root@cacti www]# cat /etc/sysconfig/i18n
LANG="ko_KR.eucKR"
SUPPORTED="ko_KR.eucKR:ko_KR:ko"
SYSFONT="lat0-sun16"
SYSFONTACM="8859-15"
mysql> show variables like 'c%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | euckr |
| character_set_connection | euckr |
| character_set_database | euckr |
| character_set_results | euckr |
| character_set_server | euckr |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | euckr_korean_ci |
| collation_database | euckr_korean_ci |
| collation_server | euckr_korean_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
+--------------------------+----------------------------+
12 rows in set (0.00 sec)
[root@cacti www]# cat /etc/my.cnf
[client]
default-character-set = euckr
[mysqld]
default-character-set = euckr
init_connect = SET collation_connection = euckr-korean_ci
init_connect = SET NAMES euckr
character-set-server = euckr
collation-server = euckr_korean_ci
[mysqldump]
default-character-set = euckr
[mysql]
default-character-set = euckr
error file : /bbs/register_form_update.php
고수님들 보시고 도움 좀 주세요.
여러 게시판 뒤져서, 한다고 해봤는데, 원인을 못찾겠네요.
아래는 제 세팅입니다.
부탁드립니다.
[root@cacti www]# cat /etc/sysconfig/i18n
LANG="ko_KR.eucKR"
SUPPORTED="ko_KR.eucKR:ko_KR:ko"
SYSFONT="lat0-sun16"
SYSFONTACM="8859-15"
mysql> show variables like 'c%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | euckr |
| character_set_connection | euckr |
| character_set_database | euckr |
| character_set_results | euckr |
| character_set_server | euckr |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | euckr_korean_ci |
| collation_database | euckr_korean_ci |
| collation_server | euckr_korean_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
+--------------------------+----------------------------+
12 rows in set (0.00 sec)
[root@cacti www]# cat /etc/my.cnf
[client]
default-character-set = euckr
[mysqld]
default-character-set = euckr
init_connect = SET collation_connection = euckr-korean_ci
init_connect = SET NAMES euckr
character-set-server = euckr
collation-server = euckr_korean_ci
[mysqldump]
default-character-set = euckr
[mysql]
default-character-set = euckr
댓글 전체
감사합니다. 인스톨시 생성되는 데이터는 한글이 깨져서 들어가나, 이후의 값들은 정상적으로 들어가네요.
photofly님 감사. 많은 도움 되었습니다.