MySQL Bugs: #18393: DB Synchronisation error

Bug #18393	DB Synchronisation error
Submitted:	21 Mar 2006 14:43	Modified:	2 May 2006 22:09
Reporter:	Gerald Siol	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S2 (Serious)
Version:	1.0.5 beta	OS:	Windows (win xp)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
i change table name and collation, then call database sync
workbench generates :
ALTER TABLE `ext_katm`.`tbl_ac_types`, RENAME TO `ext_katm`.`ts_ac_types`,
	DEFAULT CHARACTER SET latin1,
	COLLATE german_ci
and in the following the error messages:
Unknown collation: 'german_ci'

How to repeat:
reeng. a db with a table with coll swedish (default)
change table name and change coll to german
start  db sync

Suggested fix:
check the generation of the ALTER ... in the DB-Sync modul. 
Correct the generated collation name from german_ci to latin1_german_ci

Thanks for your bug report.

I was able to reporduce this by changing the collation from swedish to german.