Question
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'
Pegasystems Inc.
IN
Hi Shibesh,
There is an existing hotfix for issue with unicode character query generation. Below article explains the same:
You can raise an SR for the hotfix.
Hope it helps.
Thanks.
Coforge DPA
IN
I dont think pega7 can support nvarchar even if you expose also.
Pegasystems Inc.
IN
Hi @ShibeshM,
Do let us know the SR# once created. We will tag that to this post and track it until resolution.
Thanks!
Tata Consultancy Services
US
Created an SR SR-C65849 for hotfix HFix-31396 and installed them but the hotfix fixed only report definition not the obj-browse.
Pegasystems Inc.
IN
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,