SQL & PL/SQL

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!

conversion issue from single byte to double byte

Vikas KumarAug 27 2010 — edited Aug 27 2010

Dear All,

DB version : Oracle 10g
Client : Oracle SQL Developer

i am facing an issue with oracle to_multi_byte function. although it is converting english alphabets and other symobols into double bytes but it is not converting japanese single byte into double byte characters.

Below is the sample data:
while converting ﾄﾖﾀｶﾛ-ﾗﾅﾝｶｲ (ｶ into double byte the output has to be below:
トヨタカロ－ラナンカイ　（カ

but the output which i am receiving is below:
ﾄﾖﾀｶﾛ－ﾗﾅﾝｶｲ　（ｶ

Please let me know if there is other way round.

Regards,
Vikas Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2010

Added on Aug 27 2010

1 comment

1,320 views