Bug #8163 German umlaut in sql scripts are missing

• Submitted: 27 Jan 2005 14:25
• Modified: 28 Jun 2005 9:04
• Reporter: [ name withheld ]
• Status: No Feedback
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 1.1.5
• OS: Windows (Windows XP)
• CPU Architecture: Any

[27 Jan 2005 14:25] [ name withheld ]

Description:
If I open a sql script (file menu) with german umlauts like ä,ö,u then those don't show up in the view of the script in the query browser. Query browser simply ignores them.

How to repeat:
Open a SQL file with german umlauts and see if you can find umlauts in query browser's editor window.

Suggested fix:
Fix "File->open script" routine so that it can handle german umlauts.

[1 Feb 2005 7:40] Aleksey Kishkin

I tried to load script that was stored in utf8 with umlauts. It loads without problem and all german-specific characters were not ignored. What codepage did you use for scripts?

[4 Feb 2005 11:36] [ name withheld ]

I've added a SQL script that does not load properly in the Query Browser. Also I've attached a JPG file that shows how the SQL scripts loads in my Query Browser. 
Hope it helps!

[5 Mar 2005 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[28 Jun 2005 8:34] Christian Hass

I opened a Backup-SQL-File created with MySQL Administrator via The menu item File->OpenScirpt and got the same problem. German umlauts were ignored and replaced with other chars. I opened the SQL-File in another program (Textpad) and copied the script to a plain ScriptTab in MySQL Query Browser. This way it accepts german umlauts.

[28 Jun 2005 9:04] Michael G. Zinner

Please be aware of the fact that you have to select "SQL Script File ANSI (*.sql) in the open dialog or QB expects the file to be in UTF8 encoding.

You can select UTF8 Encoding in Notepad as well.