SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.

[iamyong]

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.

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue. Could you provide more detailed information on how to reproduce the issue?

Thank you.

[iamyong]

Hi

I'm also able to see the data from View Query, the error shows up when I hit "Preview".

[Lech Kulikowski]

Hello,

Also works fine in preview.

Thank you.

[iamyong]

Hi Lech,

We are using [OLE DB] as our datasource.

pokemon coin generator

[iamyong]

this one specifically.


pokemon coin generator

[iamyong]

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.

[Andrew]

Hello,

Do I understand you correct that the issue is resolved and no action required from Stimulsoft side?

Thank you.

[iamyong]

Hello,

Yes, that is correct. Apologies for the late reply.

Thanks,

[Andrew]

Hello,

Okay, thank you for the reply.
Closing the thread.

Have a nice day!