Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Converting to Unicode

504552Jan 17 2008 — edited Apr 10 2008
Hello, we currently have a 9.2 database that is set up as Western European. We are upgrading to 10g and we now need to support unicode. I was planning on changing all the CHAR and VARCHAR2 data types to NCHAR and NVARCHAR2. I was also going to change the character set to AL32UTF8 and the national character set to UTF8. Is this what is necessary to support unicode characters?

Can I upgrade a 9i database to 10g and convert everything? Would I be able to export the 9i database and import it in to the 10g UTF8 database? At that point all the data would be normal characters.

If any one has had experience doing this I would appreciate whatever you could provide.

Thank you kindly,

David
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2008
Added on Jan 17 2008
#general-database-discussions
12 comments
6,960 views