Bug #18791 Collations are not stored properly
Submitted: 5 Apr 2006 9:14 Modified: 24 Apr 2006 11:22
Reporter: Klaus Bensch Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Preview Severity:S3 (Non-critical)
Version:1.0.5 OS:Windows (WinXP-SP2)
Assigned to: Mike Lischke CPU Architecture:Any

[5 Apr 2006 9:14] Klaus Bensch 
Description:
A change of the standard collation is not functional will not be shown in the 'Table Editor'. A look in the .mwb File reveals, that it is stored with the wrong syntax.

before change:  
<value type="string" key="defaultCollationName">latin1_swedish_ci</value>

after change:
<value type="string" key="defaultCollationName">german_ci</value>

How to repeat:
Edit a table and change the collation from "latin1_swedish_ci" to "latin1_german_ci".

Suggested fix:
Open the *.mwb file with an editor and replace "german_ci" with "latin1_german_ci" and save. The bug is fixed.
But if you make new changes to the table, the collation fix gets lost again.
[6 Apr 2006 16:44] MySQL Verification Team 
Thank you for the bug report.
[24 Apr 2006 11:22] Mike Lischke 
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