Subject | Change Collation Sets |
---|---|
Author | marc_guillot |
Post date | 2007-03-05T19:34:19Z |
Hi.
¿ There is any simple way to change all collation sets of all string
fields in a database ?
I can only imagine to make a new empty database (with new collation
sets defineds), pump data from old database, and backup/restore to
reset index statistics.
NOTE: Now I have ES_ES collation set in Firebird 1.0.3, and I want to
upgrade to ES_ES_CI_AI in Firebird 2.0.1 (so I know I will have to
bakcup/restore almost once). I will have to upgrade 60 costumers
computers, then I am looking for the shortest way to do it.
Thank you.
¿ There is any simple way to change all collation sets of all string
fields in a database ?
I can only imagine to make a new empty database (with new collation
sets defineds), pump data from old database, and backup/restore to
reset index statistics.
NOTE: Now I have ES_ES collation set in Firebird 1.0.3, and I want to
upgrade to ES_ES_CI_AI in Firebird 2.0.1 (so I know I will have to
bakcup/restore almost once). I will have to upgrade 60 costumers
computers, then I am looking for the shortest way to do it.
Thank you.