How to get collation in generated SQL code?
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.
Subject
Views
Written By
Posted
How to get collation in generated SQL code?
794
March 15, 2017 11:15AM
396
March 15, 2017 11:18AM
357
March 15, 2017 11:26AM
296
March 15, 2017 11:34AM
466
March 16, 2017 02:01AM
439
March 17, 2017 03:21PM
394
March 20, 2017 01:58AM
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.