Navicat utf8在mysql数据库上不起作用 [英] Navicat utf8 not working on mysql database

问题描述

我目前正在尝试在两个不同步的expressionengine数据库之间合并数据更改.为此，我选择使用navicat.

I'm currently trying to merge data changes between two out of sync expressionengine databases. For this i have opted to use navicat.

该网站大量使用了模板中的希腊字符集.当我在phpmyadmin中查看希腊表字段数据时，我按预期看到了希腊语中的字符.当我将它们加载到Navicat时，我只会看到"???"问号代替他们的位置.当我尝试在数据库之间同步数据时，结果是问号代替了希腊字符.

The website makes heavy use of the greek character set in templates. When I view greek table field data in phpmyadmin, I see the characters in greek as expected. When I load them up into Navicat, I only see "???" question marks in their place. When I try to sync data between the databases, the result is that question marks are put in the place of greek characters.

有问题的字段类型是使用"utf8_general_ci"的文本".

The field types in question are "text" using "utf8_general_ci".

我在做什么错了?

推荐答案

遇到此问题，发现没有适当的答案. 解决方案是: 在MySql数据库的连接属性..."中，单击高级"选项卡，然后选中使用MySql字符集"复选框(如果您来自英国，则选中该复选框，然后表将正确显示.

Ran into this issue and saw there is no proper answer. The solution is: In Connection Properties... for your MySql database, click on the Advanced tab and check (tick if you're from UK) the box for "Use MySql character set" and then your tables will display correctly.

这篇关于Navicat utf8在mysql数据库上不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！