mysql5.1 utf8_MySQL 5.1到5.5：所有UTF-8字符都丢失了！

我决定升级我的Debian安装,几天后使用MySQL 5.5,我发现mysql打印到UTF-8字符的终端intead.

我看了一下mysqldump生成的SQL文件,发现它已经包含了垃圾.今天我删除了数据库并得到了一个旧的/ var / lib / mysql / database_name / *的副本,它运行良好,令我惊讶的是,我仍然得到相同的结果.

mysqldump生成的文件包括以下行：

/*!40101 SET NAMES utf8 */;

/*!40101 SET character_set_client = utf8 */;

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

来自旧数据库和新数据库的/var/lib/mysql/database_name/db.opt是相同的：

default-character-set=latin1

default-collation=latin1_swedish_ci

我现在能做什么？我希望我不会失去整个数据库！

UPDATE

show session variables like 'character%';

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

| Variable_name | Value |

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

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

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

SELECT charset(name), hex(name), name FROM table WHERE id='123';

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

| charset(name) | hex(name) | name |

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

| latin1 | 457361C3BA204A6F73C3A92064652053616E74616E61 | Esa?? Jos?? de Santana |

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

最后一个命令中的名称输出应为EsaúJosédeSantana