Bug #4857 Cyrillic
Submitted: 2 Aug 2004 16:42 Modified: 18 Aug 2004 0:31
Reporter: Alexey Smotrov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.0.5 OS:Windows (WinXP Pro)
Assigned to: Michael G. Zinner CPU Architecture:Any

[2 Aug 2004 16:42] Alexey Smotrov
Description:
Id does not support Cyrillic in table field’s values 8-( When I insert some values into table in Russian and then try to select from this table the MySQL Query Browser shows me “?” instead of Cyrillic chars…  

How to repeat:
Insert "&#1087;&#1088;&#1086;&#1074;&#1077;&#1088;&#1082;&#1072;" (<- word in russian) value into some table and then select it in  MySQL Query Browser
[2 Aug 2004 16:44] Alexey Smotrov
This is words in russian 8-((

Attachment: Untitled-1.gif (image/gif, text), 32.76 KiB.

[2 Aug 2004 18:02] Alexey Smotrov
No Russian

Attachment: Untitled-2.gif (image/gif, text), 43.35 KiB.

[18 Aug 2004 0:31] Michael G. Zinner
We have now fixed this in the source repository. I have created an intermediate release 1.0.5.3 to verify the bugfix. Please download from ftp://ftp.mysql.com:/pub/mysql/download/mysql_query_browser_gpl.msi

Please note that you have to set the default charset of the database you work with to an appropriate charset or the server will still convert your letters into ???.

Use: ALTER DATABASE foo CHARACTER SET cp1251; to change the database foo to the cp1251 Windows Cyrillic charset.

Then, in the Connection dialog enter foo as schema.

Enter cyrillic characters into the SQL Memo or in any column while editing the fields of a result set. It should now work as expected.