Column comments with accents are converted to normal characters when generating SQL script (4238898)

With a MySQL 5.1 database, column comments with accents (Unicode characters) are not being created in the database when generating a database creation script. Instead, they are converted to normal characters without accents. Without any parameter set in the script, the column comments with accented characters are removed by mysql server.

The database default characterset is Latin1.

By entering 'SET NAMES ascii' manually at top of the script, to indicate to the server that the script was ascii coded, it still converts the accented characters to normal characters, and removes the accents.

Go to: Settings | Options | Physical Model | SQL Script area | see the Encoding combo-box.
Default encoding is set to UTF8.

If you leave this setting as 'UTF8' and then Generate SQL in Toad Data Modeler, the following command will have to be used before executing the script in your database: SET NAMES 'utf8'

By changing the encoding here and selecting 'ANSI', then generate the SQL again, the generated script should be executed in your database without other modifications to the original script and comments.