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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center