MySQL Workbench字符集 [英] MySQL Workbench charset

问题描述

有没有办法改变MySQL Workbench字符集？我的模式使用UTF-8，当我查看表数据（保存为UTF-8）或手动添加数据时，它出现charset错误，可能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.

解决方案

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.

这篇关于MySQL Workbench字符集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！