Why Is The Euro Symbol Visible In My application But Not In Oracle SQLdeveloper When Using An UTF8/AL32UTF8 NLS_CHARACTERSET Database ? (Doc ID 1928949.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Goal

You are using an user application and there are problems with some symbols like € symbol when selecting the data in other tools like sqlplus or Oracle Sqldeveloper but the symbol is seen in the application.
When selecting € symbol inserted trough sqlplus or Oracle Sqldeveloper this is not visible in the application.
The database is an AL32UTF8 NLS_CHARACTERSET Database so this fully supports the € symbol.

When checking the actual codes inserted trough the application you notice the code stored is not correct.
(Using query: select dump(<column>,16) from table where......)

Output: Typ=1 Len=2: c2,80

Inserting the € Symbol with SQLDeveloper shows the following:

Output:Typ=1 Len=3: e2,82,ac

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms