MySQL Forums :: MySQL Workbench :: How to get collation in generated SQL code?


Advanced Search

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?

Example:
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


Subject Views Written By Posted
How to get collation in generated SQL code? 165 Sven Arild Helleland 03/15/2017 11:15AM
Re: How to get collation in generated SQL code? 70 Sven Arild Helleland 03/15/2017 11:18AM
Re: How to get collation in generated SQL code? 65 Sven Arild Helleland 03/15/2017 11:26AM
Re: How to get collation in generated SQL code? 64 Sven Arild Helleland 03/15/2017 11:34AM
Re: How to get collation in generated SQL code? 76 Mike Lischke 03/16/2017 02:01AM
Re: How to get collation in generated SQL code? 85 Sven Arild Helleland 03/17/2017 03:21PM
Re: How to get collation in generated SQL code? 79 Mike Lischke 03/20/2017 01:58AM


Sorry, only registered users may post in this forum.

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.