Euro Sign (€) Not Shown In ADF Application
(Doc ID 2655430.1)
Last updated on MAY 01, 2023
Applies to:Oracle WebLogic Server - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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 18.104.22.168.0 RAC database
create table <TABLE_NAME> (id number,<Variable_Name> varchar2(8));
insert into <TABLE_NAME> values (1,'€');
select * From <TABLE_NAME>;
drop table <TABLE_NAME>;
When setting "export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15" and running the testcase it shows:
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
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