Bug #14759 Non-ascii characters displayed incorrectly n "params" window (master/detail)
Submitted: 8 Nov 2005 16:18 Modified: 18 Sep 2006 15:58
Reporter: Gisbert Selke (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.17 OS:Windows (Win XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Generic

[8 Nov 2005 16:18] Gisbert Selke
Description:
The display of parameters in the "params" window for master/detail queries seems to have problems with non-ASCII characters. It seems to try to display the individual bytes that make up unicode characters. (Although the underlying table contains varchars marked as latin1.)

How to repeat:
Create some master table with a varchar marked as latin1 and some simple key field. Insert some non-ASCII text (like "Glück") into one of the rows. Create some other table that can serve as a detail table to the first one.

Enter some query like "select * from ...), execute.
Split pane vertically. Enter a detail query, join to master on the key. In the master pane, navigate to the row containing the non-ASCII value ("Glück").
I expect this word to come up in the "params" pane (lower right). However, I see two gibberish characters after "Gl" and before "ck". (I assume these are the raw bytes that make up the Unicode representation of "ü".)
[21 Nov 2005 17:06] Jorge del Conde
Thanks for your bug report.  I was able to reproduce this bug using 1.1.17
[18 Sep 2006 15:58] Mike Lischke
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html