Diacritics - Umlaut - Accented Characters do not display correctly
3 years ago
Originally Published: 2015-01-22
Article Number
000067684
Applies To
RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.9
Platform: JBoss
Platform (Other): Suse
O/S Version: null
Product Name: RSA-0018011
Product Description: Access Request Manager
Issue

An (entitlement) collector was run.
Names do not display correctly, although the database correctly has

Login as ACM owner (oracle).
# sqlplus / as sysdba
SQL> column parameter format A30;
SQL> column value format A20;
SQL> select * from avuser.t_system_settings where parameter='Charset';

PARAMETER                      VALUE
------------------------------ --------------------
Charset                        UTF-8


SQL> select * from  v$nls_parameters WHERE parameter like 'NLS_CHARACTERSET';

PARAMETER                      VALUE
------------------------------ --------------------
NLS_CHARACTERSET               AL32UTF8

This is the correct setting for the database and indicates that the database
can store 8 bit characters (and multi-byte)  like Western European correctly.

What you see might look like    "Jes�s" 

Resolution
When importing data into ACM, we need to ensure that

- the data is not simply ANSI. For example, your csv file should have the correct encoding that represents
 the data contained in it. If it does not, you need to convert it to the correct encoding. You can open the
CSV file in notepad and save it as utf8, for example.

- in the collector definition, for the CSV file, on the url line add charSet:

<urlstring>;charSet=ISO-8859-1;

Please note that the spelling of 'charSet' must be spelled exactly like that, with an uppercase S