Bug #5549 | Query Browser doesn't display cyrllc letters | ||
---|---|---|---|
Submitted: | 13 Sep 2004 18:55 | Modified: | 14 Sep 2004 12:39 |
Reporter: | Dmitry Kochin | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Query Browser | Severity: | S2 (Serious) |
Version: | 1.0.7 | OS: | Windows (Windows XP SP1) |
Assigned to: | CPU Architecture: | Any |
[13 Sep 2004 18:55]
Dmitry Kochin
[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