Subject | Change all collation sets in a database |
---|---|
Author | marc_guillot |
Post date | 2008-03-10T20:00:24Z |
Hello.
I want to change all varchar fields in a database from ES_ES to
ES_ES_AI_CI collation set.
All this fields are defineds trought a few Domains, I have changed
collation set of this Domains definition, but Fields has not been updated.
¿ There is any command against System Tables to do it quickly ? (I
have a lot of Tables and Fields, so I will expend a lot of time if I
must do it manually one by one).
Thank you.
I want to change all varchar fields in a database from ES_ES to
ES_ES_AI_CI collation set.
All this fields are defineds trought a few Domains, I have changed
collation set of this Domains definition, but Fields has not been updated.
¿ There is any command against System Tables to do it quickly ? (I
have a lot of Tables and Fields, so I will expend a lot of time if I
must do it manually one by one).
Thank you.