Character encoding problem!
Posted: 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:
and compare it with the very same records as displayed with the recent version:
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?
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:
and compare it with the very same records as displayed with the recent version:
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?