mysql 에서 charset 확인방법

2010.05.12 07:51

조인상 조회 수:12296

원문 : http://www.ischo.net -- 조인상 // 시스템 엔지니어

Writer : http://www.ischo.net -- ischo // System Engineer in Replubic Of Korea

+++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

본문 : http://www.ischo.net -- 조인상 //시스템 엔지니어

+++++++++++++++++++++++++++++++++++++++++++++++++++++++


언어설정 확인요령



mysql -h ip -u id -p password

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


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

설정하기

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;



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

환경설정화일에 직접 설정하기

my.ini 를 열고 편집

[mysqld]

default-character-set=euckr
character-set-client-handshake = FALSE
---------------------------------------------------------------------
서버에 요청 중입니다. 잠시만 기다려 주십시오...