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!

alter database character set internal_use UTF8

548564Feb 23 2009 — edited Feb 26 2009

hi all,
I need to migrate the database from WE8MSWIN1252 to UTF8 character set. Export/Import is one of the options but it needs very long downtime and our business does not allow it.

I then cloned the database on sand box and issued
alter database character set internal_use UTF8" but after conveting the character set our web page display chinese as default.

Please help me to sort this out. I would also like to know where the above method is good to do on production. My database is 24X7 and critical.

Alternative methods suggestion are also welcome

Please treat this mail as urgent. I have the deadline to do this task

regards
Aijaz

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Feb 23 2009

#database-upgrade

15 comments

4,832 views