Euro Sign (€) Not Shown In ADF Application (Doc ID 2655430.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

After an insert of a euro sign the ADF application is not showing it.

Insert is done from the SQL plus.
Database characterset = WE8ISO8859P15
Enterprise Edition 12.1.0.2.0 RAC database

Testcase:

create table <TABLE_NAME> (id number,<Variable_Name> varchar2(8));
insert into <TABLE_NAME> values (1,'€');
commit;
select * From <TABLE_NAME>;
drop table <TABLE_NAME>;

This shows:

        ID <Variable_Name>
---------- --------
         1 ???

When setting "export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15" and running the testcase it shows:

        ID <Variable_Name>
---------- --------
         1 €

However, the application is not showing it as € but as ¿.

When the insert of a euro sign is done within the application, it is show correctly in the application and becomes chr(164).

However, when run SQLplus:

- insert a euro sign it is shown as '???" ASCII value 191
- when the NLS_LANG is set to AMERICAN_AMERICA.WE8ISO8859P15 the previous inserted euro sign is shown as "▒▒▒", still ASCII value=191.
- when we insert a euro sign with just mentioned NLS_LANG it shows the euro sign correctly, with ASCII value 226.

The euro sign IS in ISO-8859-P15

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.