mysql(latin1 -> euckr 변경)

Pc에 mysql  설치한후 bin 디렉토리에서 실행또는 호스팅서버에 텔넷접속후 실행

mysql -h ip -u id -p password  <--db 원격 접속: 

mysql>\s

--------------
mysql  Ver 12.22 Distrib 4.0.16, for pc-linux (i686)

Connection id:          1612
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Server version:         4.0.16-Max
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 9 hours 47 min 20 sec

Threads: 6  Questions: 506708  Slow queries: 0  Opens: 16  Flush tables: 1  Open tables: 10  Queries per second avg: 14.379

--------------------------------------------------------------------------------------------------------------

설정하기

아래 euckr을 utf-8 로 변경해서 입력

mysql> SET character_set_client = euckr;
mysql> SET character_set_results = euckr;
mysql> SET character_set_connection = euckr;
mysql> ALTER DATABASE [DB명] DEFAULT CHARACTER SET euckr;
commit;

 

이렇게 하면 한글 잘됩니다.

환경은 Linux + MySQL 4.1.8입니다. ^^

---------------------------------------------------------------------------------------------------------------

환경설정화일에 직접 설정하기<----서버운용자가 반대할수있겠죠

my.ini 를 열고 편집

[mysqld]

default-character-set=euckr
character-set-client-handshake = FALSE
---------------------------------------------------------------------