Bug #20642 Default table collation should become default character field collation

• Submitted: 22 Jun 2006 22:34
• Reporter: Geoffrey Hoffman
• Status: Won't fix
• Category: MySQL Workbench Preview
• Severity: S4 (Feature request)
• Version: 1.0.6 Beta
• OS: Windows (Windows XP)
• CPU Architecture: Any

[22 Jun 2006 22:34] Geoffrey Hoffman

Description:
I would love to be able to automagically set all table and character field collation to my favorite and have that be the default, on a per model basis. Of course the other poster's suggestion about a better way to organize all the collation options would be nice too, but if I could just rely on a single default that I can change throughout my model that would be fine. 99% of the time I don't need to change it, but on the other hand, it would be nice to have a tool whereby I could easily forget that the default used to be latin1_swedish_ci ! (Okay, MySQLAB is in Sweden - I get that much.)

How to repeat:
Spend time sifting through the collation dropdown every time to find the same latin1_general_ci or utf8_ you always end up using.

Suggested fix:
Add a default collation for tables and character fields to the model preferences pane I suggested in my other post.