Why Is The Euro Symbol Visible In My application But Not In Oracle SQLdeveloper When Using An UTF8/AL32UTF8 NLS_CHARACTERSET Database ?
Last updated on DECEMBER 05, 2016
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms