mysql字符集修改无效_mysql字符集修改不成功

my.ini

[client]

port=3306

[mysql]

[b]default-character-set=utf8[/b]

# SERVER SECTION

# ----------------------------------------------------------------------

#

# The following options will be read by the MySQL Server. Make sure that

# you have installed the server correctly (see above) so it reads this

# file.

#

[mysqld]

# The TCP/IP Port the MySQL Server will listen on

port=3306

#Path to installation directory. All paths are usually resolved relative to this.

basedir="E:/Program Files/MySQL/MySQL Server 5.1/"

#Path to the database root

datadir="E:/Program Files/MySQL/Data/Data/"

# The default character set that will be used when a new schema or table is

# created and no character set is defined

[b]

default-character-set=utf8[/b]

SHOW VARIABLES LIKE '%set%';

mysql>

mysql>

mysql> SHOW VARIABLES LIKE '%set%';

+--------------------------+----------------------------------------+

| Variable_name            | Value                                  |

+--------------------------+----------------------------------------+

| auto_increment_offset    | 1                                      |

| character_set_client     | latin1                                 |

| character_set_connection | latin1                                 |

| character_set_database   | latin1                                 |

| character_set_filesystem | binary                                 |

| character_set_results    | latin1                                 |

| character_set_server     | latin1                                 |

| character_set_system     | utf8                                   |

| character_sets_dir       | E:\Program Files\sqlmy\share\charsets\ |

+--------------------------+----------------------------------------+

9 rows in set (0.00 sec)

mysql>