My Oracle Support Banner

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 NOVEMBER 25, 2020

Applies to:

Oracle Platform Security for Java - Version 11.1.1.9.0 and later
Information 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

 

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


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