User entered text are displayed with "???" in UI and DB
SummaryWhen user enters European Languages characters for text filed, value is entered into database as ?? and also in UI it looks the same.
Error MessagesNot Applicable
Steps to Reproduce
- Enter Polish or any other European language characters in text filed.
- After saving the value into DB, display same values in UI.
Root CauseTests show that all Europian language characters are shown properly in clipboard.
But after Obj-Save, the characters are converted to ??? and same is inserted in to DB tables.
It was also observed that if user inserts the same characters by SQL query, it is appearing properly in DB.
ResolutionApply below setting for SQL Data source configuration to solve the issue:sendStringParametersAsUnicode=true
Published April 4, 2017 - Updated May 2, 2017