what is 'Oracle > Option > Unicode enabled ' ?

[kilga]

First of all, I think the wrong data is stored.

But when it is enabled, I can check the data normally.
If this option is disabled, I see the Korean languages data in the grid as a question mark(???).

Why is this happening? what is the 'Unicode enabled'?

 

[Marco Kalter]

When enabled, Unicode data will be fetched as such from the Oracle Server, and displayed as Unicode text. No conversion will take place.

When disabled, Unicode data from the server will be converted to the character set of the Oracle Client, in accordance with the NLS_LANG setting of the Oracle Client. If the Oracle Client character set does not support specific database characters, the Oracle Client will convert them to question marks.

 

[kilga]

Thank you for answer.

When checking Oracle info, it is set as follows.

NLS_LANG : KOREAN_KOREA.KO16MSWIN949
NLS_CHARCTERSET : UTF8

Is NLS_LANG(KO16MSWIN949) the correct My Oracle Client character? or NLS_CHARCTERSET(UTF8) is correct?
How can I change my Oracle Client character set?

 

[Marco Kalter]

In PL/SQL Developer 15.0 you can go to Preferences > Oracle > Connection > Environment Variables and add an NLS_LANG variable with value KOREAN_KOREA.UTF8. The "Unicode enabled" option needs to be enabled as well.