Character encoding problem!

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Ziggi
Posts: 1
Joined: Mon 12 Sep 2011 21:53

Character encoding problem!

Post by Ziggi » Mon 12 Sep 2011 22:37

Hi,

For the time being I used old but nice dbForge Studio for MySQL v. 3.60 but recently there are more and more "handshaking errors" with new server versions, so I started to consider update to the most recent release.

Fine, I have installed v. 5.0.48 on my Windows 7 x64 and immediately found a big problem!!!

Please notice I live in Poland and we normally use UTF-8 text encoding for website development etc.

Please, have a look on a database records as displayed with dbForge Studio for MySQL v. 3.60:

Image

and compare it with the very same records as displayed with the recent version:

Image

You may notice that records, where Polish diacritics were used in the article title texts are corrupted!

That works both ways - all text in the database edited with new version becomes improperly encoded and it is corrupting the website.

That efficiently renders new version useless for non Latin-1 audience!

Any idea what is wrong?

Viktor
Devart Team
Posts: 68
Joined: Thu 06 May 2010 08:12

Post by Viktor » Tue 13 Sep 2011 10:33

1. Please send us DDL of your tables and inserts with data
2. Show what is set in the options Tools -> Options ->Data Editor-> Font&Colors
3. What MySQL server version are you using?

Post Reply