Search

User login

Poll

What is your favorite DB Server ?:
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
6 + 14 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

My YM

Author Information

sentono
Offline
Last seen: 6 days 18 hours ago
Joined: 09/21/2007

Alexa Rank

Who's online

There are currently 0 users and 6 guests online.
Home

Configure MySQL to Support Korean euck Charset

I just want to install a MySQL server to support euck korean charset.
Here is a short how to configure it.
Login into your server as root

Compile MySQL

#cd /root/mysql-5.0.88
#./configure --prefix=/usr/local/mysql --with-extra-charsets=complex
#make && make install

Edit my.cnf

#cp /usr/local/mysql/share/mysql/my-small.cnf /usr/local/mysql/my.cnf
#vi /usr/local/mysql/my.cnf

#add few lines below  :

[client]
default-character-set = euckr

[mysqld]
character-set-client-handshake=FALSE
init_connect="SET collation_connection = euckr_korean_ci"
init_connect="SET NAMES euckr"
default-character-set = euckr
character-set-server = euckr
collation-server = euckr_korean_ci

[mysqldump]
default-character-set = euckr

[mysql]
default-character-set = euckr

# leave other mysql setting as default
# save this files

Restart MySQL

#/usr/local/mysql/bin/mysqladmin shutdown
#/usr/local/bin/mysqld_safe --user=mysql &

 

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Recent comments

Facebook Fans

Sponsors

Online Store

Tag Cloud