MySQL ÇÑ±Û ±úÁü Çö»ó ÇØ°áÇϱâ(UTF8 ±âº»°ª ¼³Á¤Çϱâ)
MySQL ±âº» ÀÎÄÚµù
C:\ Command Prompt |
mysql> status -------------- mysql Ver 14.14 Distrib 5.7.10, for Win64 (x86_64) Connection id: 2 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.7.10 MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 TCP port: 3306 Uptime: 18 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 105 Flush tables: 1 Open tab les: 98 Queries per second avg: 0.277 |
MySQL ¼³Ä¡ÈÄ ±âº» ÀÎÄÚµù¼ÂÀ» º¯°æÇÑ ÀûÀÌ ¾ø´Ù¸é latin1À¸·Î ¼³Á¤µÇ¾î ÀÖÀ»°ÍÀÌ´Ù.
MySQL ¼³Á¤ÆÄÀÏ my.ini ¼öÁ¤
my.ini ÆÄÀÏ¿¡ ÀÌ ¼Ò½ºµéÀ» Ãß°¡ÇØÁØ´Ù.
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
ALTER ¹®À¸·Î µ¥ÀÌÅͺ£À̽º ±âº» ÀÎÄÚµù ¼Â º¯°æ
C:\ Command Prompt |
mysql> alter database basicjsp default character set utf8; Query OK, 1 row affected (0.00 sec) |
alter database [µ¥ÀÌÅͺ£À̽º¸í] default character set UTF8;
NET ¼ºñ½º Àç½ÃÀÛ
C:\ Command Prompt |
c:\>net stop mysql MySQL ¼ºñ½º¸¦ ¸ØÃä´Ï´Ù.. MySQL ¼ºñ½º¸¦ Àß ¸ØÃß¾ú½À´Ï´Ù. c:\>net start mysql MySQL ¼ºñ½º¸¦ ½ÃÀÛÇÕ´Ï´Ù.. MySQL ¼ºñ½º°¡ Àß ½ÃÀ۵Ǿú½À´Ï´Ù. |
MySQL ¼ºñ½º¸¦ Àç½ÃÀÛÇØ¾ß ±âº»¼Â Àû¿ëÀÌ µÈ´Ù.
C:\ Command Prompt |
mysql> use basicjsp Database changed mysql> status -------------- mysql Ver 14.14 Distrib 5.7.10, for Win64 (x86_64) Connection id: 2 Current database: basicjsp Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.7.10 MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 3 min 28 sec Threads: 1 Questions: 7 Slow queries: 0 Opens: 105 Flush tables: 1 Open tab les: 98 Queries per second avg: 0.033 -------------- |
basicjsp µ¥ÀÌÅͺ£À̽º status È®ÀÎ