| Bug #4943 | Column values are not displayed if they contain umlauts | ||
|---|---|---|---|
| Submitted: | 8 Aug 2004 11:21 | Modified: | 12 Aug 2004 15:56 |
| Reporter: | Simon Veith | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Query Browser | Severity: | S2 (Serious) |
| Version: | 1.0.5 alpha | OS: | Windows (Windows XP SP1) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[8 Aug 2004 13:44]
Simon Veith
Screenshot showing an example of the bug
Attachment: bug-4943-screenshot.jpg (image/pjpeg, text), 40.73 KiB.
Description: When executing a SELECT-Query, the MySQL Query Browser displays an empty cell if the cell's value contains a German Umlaut (ä, ö, ü). How to repeat: Insert a row into the table "foo" with "bar" having the value "aeiou" INSERT INTO test.foo (bar) VALUES("aeiou"); Insert another row into the table "foo" with "bar" = "äöü" INSERT INTO test.foo (bar) VALUES("äöü"); Fetch the values SELECT * FROM test.foo; MySQL Query Browser displays both rows, but the value of the second one is not displayed. phpMyAdmin has no problems with that... However, if you use that query: SELECT SUBSTRING(bar, 1, 127) FROM test.foo; the cell is displayed correctly.