Bug #41279 Synchronization replaces COLLATION
Submitted: 6 Dec 2008 17:03 Modified: 10 Jan 2009 13:40
Reporter: Cariadon Ffol Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.0.27 OS:Any
Assigned to: CPU Architecture:Any
Tags: collation, synchronization, utf8

[6 Dec 2008 17:03] Cariadon Ffol
Description:
The synchronization function doesn't seem to follow the model's collation if it is set to 'Table default', and replaces the column's collation.

How to repeat:
Create new schema and set Collation to 'utf8_swedish_ci'.
Create a table and set Collation to 'Schema Default'.
Create a column of type VARCHAR and set Collation to 'Table Default'.

Do a Forward Engineer and create the table.

Now the column will have the correct collation.

Do a Synchronization. The collation will be changed to 'utf8_generic_ci'.

Suggested fix:
The collation should be kept when doing a synchronization if the column's collation (in the model) is 'Table Default' and the table's collation is matching the column's current collation (in database).
[10 Dec 2008 13:40] MySQL Verification Team
Thank you for the bug report. Could you please try new 5.0.28 version and if the issue continues please provide a sample project attaching it here. Thanks in advance.
[11 Jan 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".