Bug #6403 Query Browser 'swallows' accentuated characters when opening a script
Submitted: 3 Nov 2004 14:56 Modified: 15 Nov 2004 10:12
Reporter: Luis Sérgio Moura Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.0 OS:Windows (WinXP Pro)
Assigned to: Mike Lischke CPU Architecture:Any

[3 Nov 2004 14:56] Luis Sérgio Moura 
Description:
When opening a file with accentuated characters (áàçõ etc...), these characters vanishes from the document.

How to repeat:
Save the following script to a file and open as a script in the query browser, and you'll notice that the 'è' and 'ú' characters from 'dèja vú' are missing..

USE test;

DROP TABLE IF EXISTS bug;

CREATE TABLE bug (
 id int(11),
 test varchar(20)
);

INSERT INTO bug VALUES (5, 'test1');
INSERT INTO bug VALUES (6, 'dèja vú');
[5 Nov 2004 16:33] Mike Lischke 
How did you create the script? Make sure it is encoded in utf8 or take care when you open it as utf8 is now the default encoding for scripts in QB. You can select the text encoding to be used when loading a script in the open dialog.
[15 Nov 2004 10:12] Mike Lischke 
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.