MySQL Bugs: #6532: MySQL Admin ignores "ANSI quotes" backup option

Bug #6532	MySQL Admin ignores "ANSI quotes" backup option
Submitted:	9 Nov 2004 22:28	Modified:	16 Nov 2004 11:52
Reporter:	Adam Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.14	OS:	Windows (Windows)
Assigned to:	Victor Vagin	CPU Architecture:	Any

Description:
Backup a database with MySQL Administrator 1.0.14 for Windows. On the Advanced Options tab, select a backup type=SQL files. Use defaults for the rest of the checkboxes, but ensure that "ANSI quotes" is unchecked.

The SQL file output file has double-quotes in it, even though the "ANSI quotes" checkbox is empty. Check the "ANSI quotes" checkbox and perform the backup again, you still get double-quote characters in the SQL file output. This "ANSI quotes" setting is being ingnored and thus creating invalid SQL files that MySQL Administrator cannot read to do Restores with.

Here's a snippet from the SQL file showing the double-quotes that cause problems.
It seems to be mixing the use of double and single quotes as well:

CREATE TABLE "mudcommands" (
  "actorid" varchar(40) NOT NULL default '',
  "type" int(11) NOT NULL default '0',
  "commandname" varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

How to repeat:
Backup a database with MySQL Administrator 1.0.14 for Windows. On the Advanced Options tab, select a backup type=SQL files. Use defaults for the rest of the checkboxes, but ensure that "ANSI quotes" is unchecked.

The SQL file output file has double-quotes in it, even though the "ANSI quotes" checkbox is empty.

Suggested fix:
Don't know.

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

please note, you can't use 'ansi quotes' for mysql-4.0 server because 
it doesn't support it