Navicat utf8 not working on mysql database

2019-07-22 12:49发布

I'm currently trying to merge data changes between two out of sync expressionengine databases. For this i have opted to use 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.

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

what am i doing wrong?

2条回答
Ridiculous、
2楼-- · 2019-07-22 13:25

I had the same probem with Navicat Linux... The problem was solved following these steps:

  1. In Navicat, open your table in design view.
  2. Under Fields tab, select the fields which require to show as Unicode. Change the Character set and Collation into utf8 and uft8_general_ci.
  3. Under Options tab, change the Character set and Collation into utf8--UTF-8 Unicode and uft8_general_ci.
  4. Save.
  5. Select Tools > Options. Under Font, change the "Editor Font" into e.g. AR PL ZenKai Uni .
  6. Re-start your Navicat.

    • Select the correct "Editor Font" in Options until it shows your data correctly. (Repeat steps 5 and 6 above.)

Source: http://wiki.navicat.com/wiki/index.php/How_can_I_display_Unicode_in_Linux%3F

查看更多
Bombasti
3楼-- · 2019-07-22 13:32

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.

查看更多
登录 后发表回答