Changing your database from one collation to another may be a good idea for any number of reasons. It can be especially useful, for example, to:
Avoid character set translation across your setup.
Match the characters in your database to the collation in your database. Using the same character set defined in your database is especially important when sorting.
Use a different character set. You may, for example, want to move from an OEM character set to a Windows character set.
Simply modifying the collation in an existing database would invalidate indexes for that database, and is not permitted. To change the collation for a database, you must rebuild the database. Rebuilding creates a new database with new settings (including collation settings). You will then need to load the data from a flat file or using INSERT ..LOCATION.
