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

Accented character issue on Postgres DB

SA-57607

Summary



A record configured in the data type with data 'helló' (o - small accented character). When applying the filter from the Search text box on this column and clicking Apply, the results do not display.


Error Messages



Not Applicable


Steps to Reproduce

  1. Configure a data type with some records that contain accented characters.
  2. Filter the records by applying the Filter in the Search box for accented characters. 


Root Cause



The query formed for filter condition,



The ​filter performs UPPER of the column and its value. In this case, name is converted to NAME and value as MÔRNING.
In the user scenario, the query execution does not convert 'accented o' to upper case when UPPER is performed.





Resolution



Here's the explanation for the reported behavior:

Limitation or issue in the database for the support of accented characters due to the results are inconsistent.


 
Suggest Edit

Published August 24, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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