Re: Change default collation for charset?
Posted by:
Rick James
Date: December 28, 2009 10:16PM
I think you are stuck doing a bunch of ALTER TABLEs to change the collation of each column individually.
The collation of a column is determined at CREATE TABLE time. Changing the "default" collation at table or database or server level will not change the collation of existing columns, only of any new columns (and new tables, etc).
utf8_unicode_ci is "better" than utf8_general_ci. But it is not 'perfect' for many languages. As long as you want something generic, it is the best collation.
Subject
Views
Written By
Posted
17697
December 19, 2009 05:32PM
8440
December 19, 2009 06:54PM
Re: Change default collation for charset?
7357
December 28, 2009 10:16PM
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.