OPSS 11g/12c: EM Application Role In Japanese Shows Garbled If OPSS Schema Using WE8MSWIN1252 as NLS_CHARACTERSET For BIEE
(Doc ID 2730887.1)
Last updated on MAY 12, 2021
Applies to:
Oracle Platform Security for Java - Version 11.1.1.9.0 and laterInformation in this document applies to any platform.
Goal
User added an application role on the EM screen, but when enter Japanese and save it, it cannot be displayed properly and the characters are garbled.
Example: 201_XXBI_<JAPANESE WORD> in charge showed as 201_XXBI_???
sqlplus / as sysdba
SQL> select value from NLS_DATABASE_PARAMETERS where Parameter='NLS_CHARACTERSET';
VALUE
--------------------------------------------------------------------------------
JA16SJISTILDE
SQL> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_NCHAR_CHARACTERSET';
VALUE
--------------------------------------------------------------------------------
AL16UTF16
sqlplus XXX_OPSS/<USER>@<DB_HOST_NAME>
[Thu Oct 08 18:19:05.333 2020] NLS_CHARACTERSET
[Thu Oct 08 18:19:05.333 2020] WE8MSWIN1252
SQL> select value from NLS_DATABASE_PARAMETERS where Parameter='NLS_CHARACTERSET';
VALUE
--------------------------------------------------------------------------------
JA16SJISTILDE
SQL> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_NCHAR_CHARACTERSET';
VALUE
--------------------------------------------------------------------------------
AL16UTF16
sqlplus XXX_OPSS/<USER>@<DB_HOST_NAME>
[Thu Oct 08 18:19:05.333 2020] NLS_CHARACTERSET
[Thu Oct 08 18:19:05.333 2020] WE8MSWIN1252
Solution
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
Goal |
Solution |
References |