안녕하세요

 

현재 서버 locale은 utf로 되어있는 상태구요.

 

mysql 또한 utf로 설정이 되어있습니다.

 

서버 버전: 4.1.11-Debian_4sarge7-log Protocol version: 10 서버: Localhost via UNIX socket 사용자: root@localhost MySQL 문자셋: UTF-8 Unicode (utf8) MySQL connection collation: Collation armscii8_bin armscii8_general_ci ascii_bin ascii_general_ci big5_bin big5_chinese_ci binary cp1250_bin cp1250_czech_cs cp1250_general_ci cp1251_bin cp1251_bulgarian_ci cp1251_general_ci cp1251_general_cs cp1251_ukrainian_ci cp1256_bin cp1256_general_ci cp1257_bin cp1257_general_ci cp1257_lithuanian_ci cp850_bin cp850_general_ci cp852_bin cp852_general_ci cp866_bin cp866_general_ci dec8_bin dec8_swedish_ci euckr_bin euckr_korean_ci gb2312_bin gb2312_chinese_ci gbk_bin gbk_chinese_ci geostd8_bin geostd8_general_ci greek_bin greek_general_ci hebrew_bin hebrew_general_ci hp8_bin hp8_english_ci keybcs2_bin keybcs2_general_ci koi8r_bin koi8r_general_ci koi8u_bin koi8u_general_ci latin1_bin latin1_danish_ci latin1_general_ci latin1_general_cs latin1_german1_ci latin1_german2_ci latin1_spanish_ci latin1_swedish_ci latin2_bin latin2_croatian_ci latin2_czech_cs latin2_general_ci latin2_hungarian_ci latin5_bin latin5_turkish_ci latin7_bin latin7_estonian_cs latin7_general_ci latin7_general_cs macce_bin macce_general_ci macroman_bin macroman_general_ci sjis_bin sjis_japanese_ci swe7_bin swe7_swedish_ci tis620_bin tis620_thai_ci ucs2_bin ucs2_czech_ci ucs2_danish_ci ucs2_estonian_ci ucs2_general_ci ucs2_icelandic_ci ucs2_latvian_ci ucs2_lithuanian_ci ucs2_persian_ci ucs2_polish_ci ucs2_roman_ci ucs2_romanian_ci ucs2_slovak_ci ucs2_slovenian_ci ucs2_spanish2_ci ucs2_spanish_ci ucs2_swedish_ci ucs2_turkish_ci ucs2_unicode_ci ujis_bin ujis_japanese_ci utf8_bin utf8_czech_ci utf8_danish_ci utf8_estonian_ci utf8_general_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_persian_ci utf8_polish_ci utf8_roman_ci utf8_romanian_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_unicode_ci

mysql> show variables like 'c%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
| collation_connection     | utf8_general_ci            |
| collation_database       | utf8_general_ci            |
| collation_server         | utf8_general_ci            |
| concurrent_insert        | ON                         |
| connect_timeout          | 5                          |
+--------------------------+----------------------------+
12 rows in set (0.01 sec)

 

 

현재 문제점이 새로 가입한 회원은 제대로 db에 들어가지만

 

처음 계정 설정시 admin의 정보가 위의 이미지대로 mb_password/mb_jumin과 같이 깨진 상태로 입력이 됩니다.

 

그리고 그누보드 테이블들이 collation이 ucs2_general_ci로 설정이 되어있는데 이게 정상인가요?

 

설치 버전은 utf 버전 제일 마지막에 나온것입니다.

 

답변 부탁드립니다 (__ )