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!

How to change the Character Set from AL32UTF8 to WE8DEC

560333Apr 18 2007 — edited Apr 20 2007

Hello!!

I want to know how to change the character set in the database from AL32UTF8 to WE8DEC.

I tried to use the comand ALTER DATABASE CHARACTER SET but I got an error because WE8DEC is not a superset of AL32UTF8.

I need to import tables from a server that uses WE8DEC. So when I do the import to my server, wich has AL32UTF8 , I can't import the rows that include an Ñ.

So I want to change the caracter set to WE8DEC. How can I do it?

Is it needed to change the language configuration? The remote server has AMERICAN_AMERICA, and my server has MEXICAN SPANISH_MEXICO (both uses text in spanish).

Thanks a lot!!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 17 2007

Added on Apr 18 2007

#general-database-discussions

5 comments

1,491 views