Changing character set in database
If your database is using anything else than UTF8 as database character set you may consider to migrate from it. Oracle states in the Globalization Guide (10gR2): At the top of the list of character sets Oracle recommends for all new system deployment is the Unicode character set AL32UTF8. Depending on what characters you actually have in your database you have three options on how to do this: Changing the character set with the package CSALTER. Only data dictionary is migrated. ...