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!

Translate Japanese Characters to English in pl/sql

User_H6M8AFeb 27 2019 — edited Feb 27 2019

Hello gurus,

I have a japanese words like お世話になっております。I need to translate to English in Oracle.

I have NLS character set in Oracle as UTF8

I tried doing it but its not translating

SELECT CONVERT('お世話になっております。','UTF8','AL32UTF8') FROM dual

Added on Feb 27 2019

9 comments

1,490 views