Database Administration (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center