Bug #5549 Query Browser doesn't display cyrllc letters

• Submitted: 13 Sep 2004 18:55
• Modified: 14 Sep 2004 12:39
• Reporter: Dmitry Kochin
• Status: Can't repeat
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 1.0.7
• OS: Windows (Windows XP SP1)
• CPU Architecture: Any

[13 Sep 2004 18:55] Dmitry Kochin

Description:
Query Browser doesn't dysplay cyrillic letters in result sets, although I have selected cyrillic fonts in Tools\Options.
MySQCC displays cyrillic letters correctly.

How to repeat:
Add some russian words into mysql database table.
The select this data with a SQL query.
You will not see cyrillic letters.

Suggested fix:
Make it work the same as MySQLCC. It doesn't have this problem in result sets (although it does have this problem in data export to a file).

[14 Sep 2004 12:39] MySQL Verification Team

Hi,

Thank you for the report, but I wasn't able to repeat it. It works fine for me on v1.0.7 Query Browser and MySQL server v4.0/4.1/5.0. Be aware that you set client and connection character set properly.

[14 Sep 2004 13:53] Dmitry Kochin

Actually, you get the strings out of MySql in UTF8 encoding. However, this UTF8 encoding seems to be wrong for russian letters.
For example. I open standard windows editor 'notepad' and enter russian letter A, then save it in UTF8 encoding.
The russian letter A is encoded as D0 90
When I export the result set using mysql query browser. The same letter A is encoded as C3 80.

I believe there is something wrong with the UTF encoding.

[12 May 2006 6:01] Peter Trifonov

The problem was reproduced with query browser v. 1.1.18.
There is a database with table containing cp1251 data. 
One of entries looks like

Вниманию студентов кафедры РВКС, а также всех желающих заниматься научно-исследовательской работой под руководством ее сотрудников, предлагается список возможных  <a href=""data/
topics.pdf"">тем</a> исследований. MySQL query browser has exported this entry as (hex dump):

22 62 6F 64 79 22 2C 22  49 44 22 0D 0A 22 C3 82
C3 AD C3 A8 C3 AC C3 A0  C3 AD C3 A8 C3 BE 20 C3
B1 C3 B2 C3 B3 C3 A4 C3  A5 C3 AD C3 B2 C3 AE C3
A2 20 C3 AA C3 A0 C3 B4  C3 A5 C3 A4 C3 B0 C3 BB
20 C3 90 C3 82 C3 8A C3  91 2C 20 C3 A0 20 C3 B2
C3 A0 C3 AA C3 A6 C3 A5 20 C3 A2 C3 B1 C3 A5 C3
B5 20 C3 A6 C3 A5 C3 AB  C3 A0 C3 BE C3 B9 C3 A8
C3 B5 20 C3 A7 C3 A0 C3  AD C3 A8 C3 AC C3 A0 C3
B2 C3 BC C3 B1 C3 BF 20  0D 0A C3 AD C3 A0 C3 B3
C3 B7 C3 AD C3 AE 2D C3 A8 C3 B1 C3 B1 C3 AB C3
A5 C3 A4 C3 AE C3 A2 C3  A0 C3 B2 C3 A5 C3 AB C3
BC C3 B1 C3 AA C3 AE C3  A9 20 C3 B0 C3 A0 C3 A1
C3 AE C3 B2 C3 AE C3 A9  20 C3 AF C3 AE C3 A4 20
C3 B0 C3 B3 C3 AA C3 AE  C3 A2 C3 AE C3 A4 C3 B1
C3 B2 C3 A2 C3 AE C3 AC  20 C3 A5 C3 A5 20 C3 B1
C3 AE C3 B2 C3 B0 C3 B3  C3 A4 C3 AD C3 A8 C3 AA
C3 AE C3 A2 2C 20 0D 0A  C3 AF C3 B0 C3 A5 C3 A4
C3 AB C3 A0 C3 A3 C3 A0  C3 A5 C3 B2 C3 B1 C3 BF
20 3C 61 20 68 72 65 66   3D 22 22 64 61 74 61 2F
74 6F 70 69 63 73 2E 70  64 66 22 22 3E C3 B1 C3
AF C3 A8 C3 B1 C3 AE C3  AA 3C 2F 61 3E 20 C3 A2
C3 AE C3 A7 C3 AC C3 AE  C3 A6 C3 AD C3 BB C3 B5
20 C3 B2 C3 A5 C3 AC 20  0D 0A C3 A8 C3 B1 C3 B1
C3 AB C3 A5 C3 A4 C3 AE  C3 A2 C3 A0 C3 AD C3 A8
C3 A9 2E 20 22 2C 35 30  0D 0A