My Oracle Support Banner

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

Last updated on APRIL 24, 2020

Applies to:

Oracle WebLogic Server - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


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