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 &
Recent blog posts |
Recent comments
|
Comments
Post new comment