Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Field value displays bullet point symbols incorrectly

SA-81979

Summary



Field value displays the bullet point symbols incorrectly.


Error Messages



Not Applicable


Steps to Reproduce

  1. Add a few lines to the Field Value rule which contains bulleted lines
  2. Add a field value to the section. Verify the UI.


Root Cause



The encoding in the database was incorrect. The WE8ISO8858P1 was included in the Oracle database.


Resolution



Perform the following local-change:

Configure the database for localization. 


Oracle supports two types of character semantics, BYTE and CHAR. CHAR supports international character sets. 

To support localization, set Oracle semantics to CHAR:
  1. In the Oracle database, set the database character set to AL32UTF8 (For more information, refer to the Oracle documentation).
  2. Run the following command to set the initialization parameter NLS_LENGTH_SEMANTICS to CHAR to handle multi-byte UNICODE characters:

    ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR scope=both;
     
  3. Restart database services.
  4. Configure the semantics settings:

    a. On the database server, open the file SPFILEDfîA/AME.ora in the database directory.
    b. Configure the settings as below:

    NLS_LENGTH_SEMANTICS=CHAR scope=both;
    NLS_CHARACTERSET=AL32UTF8;
    NLS NCHAR C HARACT E R S E T =AL16UTF16;

    c. Save and close the file.
     
  5. Set NLS_LENGTH_SEMANTICS to CHAR for the session to ensure that the database access tool does not override the default semantics setting for the session.

    For more information, refer to the database access tool documentation.

Published August 19, 2019 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us