SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Good Day,
So I have a stimulsoft report that is working on SS Ultimate 2014.3 designer. However, when I tried to run the report with SS Ultimate 2019.2.3, I get the error below:
I was able to determine that the cause of the error was when my queries were trying to concatenate chinese characters, sample:
SELECT CONCAT(YEAR(GETDATE()), N'年', MONTH(GETDATE()), N'月', DAY(GETDATE()), N'日')
and when my sql statements had chinese text in the WHERE clause, sample:
SELECT N'增加'
Am I missing something in SS thats causing this error? Also, I'm connecting to one single database when running the report between the two SS versions mentioned above.
Thank You.
So I have a stimulsoft report that is working on SS Ultimate 2014.3 designer. However, when I tried to run the report with SS Ultimate 2019.2.3, I get the error below:
I was able to determine that the cause of the error was when my queries were trying to concatenate chinese characters, sample:
SELECT CONCAT(YEAR(GETDATE()), N'年', MONTH(GETDATE()), N'月', DAY(GETDATE()), N'日')
and when my sql statements had chinese text in the WHERE clause, sample:
SELECT N'增加'
Am I missing something in SS thats causing this error? Also, I'm connecting to one single database when running the report between the two SS versions mentioned above.
Thank You.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Hello,
We couldn't reproduce the issue. Could you provide more detailed information on how to reproduce the issue?
Thank you.
We couldn't reproduce the issue. Could you provide more detailed information on how to reproduce the issue?
Thank you.
- Attachments
-
- Annotation 2019-05-22 092927.jpg (135.54 KiB) Viewed 5448 times
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Hi
I'm also able to see the data from View Query, the error shows up when I hit "Preview".
I'm also able to see the data from View Query, the error shows up when I hit "Preview".
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Hello,
Also works fine in preview.
Thank you.
Also works fine in preview.
Thank you.
- Attachments
-
- Annotation 2019-05-22 142645.jpg (183.65 KiB) Viewed 5442 times
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
I found the issue, one of my datasources was of the type Stored Procedure but it was supposed to be Query. Please note that the report was working on SS Ultimate 2014.3 even if the datasource was typed as Stored Procedure instead of Table.
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Hello,
Do I understand you correct that the issue is resolved and no action required from Stimulsoft side?
Thank you.
Do I understand you correct that the issue is resolved and no action required from Stimulsoft side?
Thank you.
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Hello,
Yes, that is correct. Apologies for the late reply.
Thanks,
Yes, that is correct. Apologies for the late reply.
Thanks,
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Hello,
Okay, thank you for the reply.
Closing the thread.
Have a nice day!
Okay, thank you for the reply.
Closing the thread.
Have a nice day!