Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Transforming Traditional Chinese Characters to Simplified Chinese Character

414444Feb 8 2004 — edited Dec 12 2005

Dear All,

I have an Unicode database which is storing Traditional Chinese Characters, and now I am facing two urgent problems that I cannot solve:

1) Can I configure Oracle to transform the Traditional Chinese Characters to Simplified Chinese Characters on-the-fly? If yes, how should I configure the database and nls_lang parameters? The database has character set AL32UTF8 and national character set AL16UTF16 now, so I think I should configure the nls_lang environment variable, right? I have tried :
SIMPLIFIED CHINESE_HONG KONG.ZHS16GBK
SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280
But in vain, any body can advise me?

2) How can I populate a column (field) to store Simplified Chinese Characters from another field storing Traditional Chinese Characters in the database? How the mapping can be done in Oracle? Is there any SQL command or API we can use to achieve this goal?

Please kindly advise me on how to do these as I need to solve them this week. Many thanks.

Kel

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 9 2006

Added on Feb 8 2004

#database-key-features, #globalization-support

21 comments

7,318 views