How to configure SQL Developer to display Text in database encoding?
Hi all,
I want to use SQL Developer (Windows, 20.2.0.175) to query a table, which contains text in different languages. The text is stored using UTF-8.
Since the 19c database NLS_CHARACTERSET is AL32UTF8, I was surprised to see that SQL Developer shows characters not as they are stored.
German, English, Russian 'Lizenz OK', 'License OK', 'Ð›Ð¸Ñ†ÐµÐ½Ð·Ð¸Ñ Ð´ÐµÐ¹Ñтвительна'
I tried setting the encoding of SQL Developer:
[Tools] --> [Preferences] --> [Environment] --> Encoding: "UTF-8"
I have restarted SQL Developer, but the settings seems to have no effect on displaying query results.
Does anyone have a tip?