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 AUGUST 04, 2018
Applies to:Oracle Database - Standard Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!