Utf-8 Encoding Issue

[Igor]

We deal with international data content, as well as English. So some of our data comes in cyrillic, for example.

While data is correctly stored in utf-8 format, it is not being properly displayed by SQLyog.

The data is however being correctly displayed by MySQL Query Browser.

See attached (2nd line in the result set – I apologize for the small font there).

Thanks for your help!

Igor.

[peterlaursen]

Please refer to:

http://webyog.com/faq/34_102_en.html

When connecting with SQLyog try choosing some cyrillic charset in the connections manager 'dropdown' and not 'default'. Most likely cp1251 would be best choice. You should be able to display latin and cyrillic characters at the same time. But you will need a recent SQLyog version to have the 'dropdown' option.

Cyrillic character sets in MySQL: http://dev.mysql.com/doc/refman/5.0/en/cha…illic-sets.html

Is your windows localisation Russian or English?

BTW: we do intend to use UNICODE internally with SQLyog very soon!

.. and please attach the graphics files directly. The WORD document is hard to read!

[Igor]

Peter, thanks for your quick replies!!!

I am in US, San Francisco Bay Area, so yeah, we use English localization of Windows. We need to have unicode, not just cyrillic. Cyrillic was just an example of one of my CDs, as well… I am from over there! BTW, Vyborg a city very close to the one I am from – St. Petersburg! 🙂 But this is of course different Vyborg – the one on Finnish border.

So I'll be waiting for your unicode release!

Thanks again for your help!

Igor.

PS. About 10 years ago by now I was one of three developers who did one of the first IDEs for Oracle – Platinum SQL Station. So am very much familiar with the problems you are facing…

[peterlaursen]

I am sorry to disappoint you.

… but 'Viborg' is not 'Vyborg'. 'Vyborg is an old Swedish/Finnish spelling of 'Viborg'. Viborg is in Denmark and Vyborg is located close to the Finnish/Russian border.

Vi or Vy means 'holy/sacred place' in the ancient nordic language spoken at the time of the Viking Era. Viborg probably was the most important religious place in Denmark before christianity arrived!

[Igor]

peterlaursen wrote on Sep 5 2006, 08:18 PM:

I am sorry to disappoint you.

… but 'Viborg' is not 'Vyborg'. 'Vyborg is an old Swedish/Finnish spelling of 'Viborg'. Viborg is in Denmark and Vyborg is located close to the Finnish/Russian border.

Vi or Vy means 'holy/sacred place' in the ancient nordic language spoken at the time of the Viking Era. Viborg probably was the most important religious place in Denmark before christianity arrived!

You are not disappointing me. I knew that you were in Denmark and that the cities are different. I was in Denmark myself last summer (not in Jutland though). Have fun!

[Author]

Posts