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'
I dont think pega7 can support nvarchar even if you expose also.
Hi ShibeshM,
Do let us know the SR# once created. We will tag that to this post and track it until resolution.
Thanks!
Created an SR SR-C65849 for hotfix HFix-31396 and installed them but the hotfix fixed only report definition not the obj-browse.
Hello,
I took a quick look into the SR case notes and see that HFix-31396 was requested by you and the SR was closed. Please re-open teh SR to continue investigation.
Thanks,
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-re…
You can raise an SR for the hotfix.
Hope it helps.
Thanks.