MySQL Forums
Forum List  »  MySQL Workbench

How to get collation in generated SQL code?
Posted by: Sven Arild Helleland
Date: March 15, 2017 11:15AM

Switched to a new laptop, and upgraded to WorkBench version 6.3.8 from 6.3.3.

My question is, how do I get the "Copy SQL to Clipboard" function to generate the collation for the charset again?

In 6.3.8 it add: CHARACTER SET 'latin1'

In 6.3.3 it add: CHARACTER SET 'latin1' COLLATE 'latin1_general_ci'

That it does not add the collation create a unneeded issues regarding foreign keys if the database server does not run the same default collation for the character set as used in the tables.

I.e. This cause a lot of unneeded editing of the SQL code generated to manually add the collation to not make the query fail due to the foreign key cannot be created due to mismatch between the columns.

I have looked over the settings several times and cannot find the ability to change this, so hope someone can help me in the right direction.

Options: ReplyQuote

Written By
How to get collation in generated SQL code?
March 15, 2017 11:15AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.