Question
5
Replies
102
Views
Posted: September 25, 2018
Last activity: October 11, 2018
Obj-Browse fails to return rows with Japanese character(Unicode nvarchar column)
I am having an exposed column of type nvarchar and inserted a record to have Japanese character in it (eg. FileName = 'Japanese testing こんにちは.docx') but obj-browse don't return this column.
Note: direct SQL query also don't return result and I have to give SQL query as below to get an output.
where FileName = N'Japanese testing こんにちは.docx'
Hi Shibesh,
There is an existing hotfix for issue with unicode character query generation. Below article explains the same:
https://community.pega.com/support/support-articles/filter-condition-report-definition-rule-does-match-unicode
You can raise an SR for the hotfix.
Hope it helps.
Thanks.