MariaDB utf-8 문자셋 설정 -
[root@localhost ~]# vi /etc/my.cnf.d/client.cnf
-> insert(press) ->
[client]
default-character-set = utf8 |
-> esc(press) -> :wq
[root@localhost ~]# vi /etc/my.cnf.d/mysql-clients.cnf
-> insert(press) ->
[mysql]
default-character-set = utf8
[mysqldump]
default-character-set = utf8 |
-> esc(press) -> :wq
[root@localhost ~]# vi /etc/my.cnf.d/server.cnf
-> insert(press) ->
[mysqld]
init_connect = "SET collation_connection = utf8_general_ci"
init_connect = "SET NAMES utf8"
character-set-server=utf8
collation-server = utf8_general_ci |
-> esc(press) -> :wq
[root@localhost ~]# mysql -u계정 -p비번
show variables like 'c%';
exit
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| 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 |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 10 |
+--------------------------+----------------------------+ |
[root@localhost ~]# vi /etc/my.cnf
-> insert(press) ->
[client]
default-character-set = utf8
[mysqld]
init_connect = "SET collation_connection = utf8_general_ci"
init_connect = "SET NAMES utf8"
default-character-set=utf8 //--- 오류가 발생하여 mysql 데몬이 기동되지 않을 경우 삭제 하세요.
character-set-server=utf8
collation-server = utf8_general_ci
[mysqldump]
default-character-set = utf8
[mysql]
default-character-set = utf8 |
-> esc(press) -> :wq
nginx utf-8 문자셋 설정 -
[root@localhost ~]# vi /etc/nginx/nginx.conf
-> insert(press) ->
http {
include /etc/nginx/mime.types;
default_type application/octet-stream;
charset UTF-8; |
-> esc(press) -> :wq
[root@localhost ~]# vi /etc/nginx/sites-available/ossnode101.conf
-> insert(press) ->
server {
server_name ossnode101.ossbiz.co.kr;
access_log /nas/www/ossnode101/logs/access.log;
error_log /nas/www/ossnode101/logs/error.log;
root /nas/www/ossnode101/public_html;
charset UTF-8; |
-> esc(press) -> :wq
php utf-8 문자셋 설정 -
[root@localhost ~]# vi /etc/php.ini
-> insert(press) ->
[PHP]
default_charset = "UTF-8"
magic_quotes_gpc = Off
output_buffering = 4096
output_handler = mb_output_handler
[mbstring]
mbstring.language = UTF-8
mbstring.internal_encoding = UTF-8
mbstring.http_input = auto
mbstring.http_output = UTF-8
mbstring.encoding_translation = On
mbstring.detect_order = auto
mbstring.substitute_character = none; |
-> esc(press) -> :wq
[root@localhost ~]# service nginx restart
[root@localhost ~]# service php-fpm restart
[root@localhost ~]# service mysql restart
마지막으로 쿼리문에 아래와 같은 내용 추가 -
mysql_query("set session character_set_connection=utf8;");
mysql_query("set session character_set_results=utf8;");
mysql_query("set session character_set_client=utf8;"); |
참고 포스트 -
http://www.jopenbusiness.com/mediawiki/index.php?title=%EB%AC%B8%EC%9E%90%EC%85%8B%EA%B3%BC_%EC%9D%B8%EC%BD%94%EB%94%A9
http://zolasse.blogspot.kr/2014/07/mysqlmariadb.html
http://webdir.tistory.com/258
http://ra2kstar.tistory.com/59