MySQL 工作台字符集

是否有任何方法可以更改 MySQL Workbench 字符集?我的架构使用 UTF-8,当我查看表数据(另存为 UTF-8)或手动添加数据时,出现字符集错误,可能 MySQL Workbench 使用 LATIN1.

Does there exist any way to change the MySQL Workbench charset? My schema uses UTF-8 and when I view the table data (saved as UTF-8) or add data manually, it appears with charset errors, probably MySQL Workbench uses LATIN1.

推荐答案

我认为 OP 在询问 Workbench 在其编辑器中使用的字符集以及如何设置 Workbench 以在 GUI 中使用 UTF-8 - 而不是如何设置使用的默认字符集用于 Workbench 中的数据库表.目前在 Workbench 中可以设置数据库表字符集,但无论如何 Workbench 将在它的 GUI 中使用 Latin1 字符集表示数据!!!此外,通过 Workbench 将数据插入到 UTF-8 表中会导致数据库中出现错误的字符.我也不知道如何让 Workbench 在其 GUI 中处理 UTF-8.

I think OP was asking about charset that Workbench uses in its editor and how to setup Workbench to use UTF-8 in GUI - not how to setup default charset used for database table in Workbench. At the moment in Workbench one can set database table charset but regardless of it Workbench will in it's GUI represent data using Latin1 charset!!! Also inserting data into UTF-8 tables through Workbench will result with wrong chars in database. I don't know either how to make Workbench deal with UTF-8 in its GUI.

相关文章