utf8 in pl/sql 7.1.4

[ybaekkim]

I tried below query in "SQL window" which includes korean character.

select convert('한글테스트 UTF', 'UTF8') from dual;

But, the result failed because korean character looks like '??????'.

I confused what to do to fix it.

May I change 'prefences' in pl/sql 7.1.4 and contact to the DBA?

Would you have any other comments to solve this problem?

 

[Marco Kalter]

This requires that the client character set of your Oracle NLS_LANG is UTF8. Can you confirm this?

Furthermore the "Unicode enabled" preference (Tools > Preferences > Oracle / Options) must be enabled.

 

[ybaekkim]

Convert('ABC','UTF8') means that 'ABC' string is tried to convert from my oracle NLS_LANG to UTF8.

I don't think that my oracle NLS_LANG set should be UTF8.

And "Unicode enabled" is already enabled.

Anyway Thank you for your comment.

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?