Skip to Content
Jan 20, 2020 at 02:15 PM

How to handle ASCI characters in update query using DI Server ExecuteSQL?

55 Views Last edit Jan 20, 2020 at 02:19 PM 2 rev

Hi Expert ,

I am trying to Update a field value with ASCI character .I am using ExecuteSQL command of DI Server service. Below is my query format :">




<DoQuery>Update OCRD set CardName='jkł mno' where Cardcode = 'ABCD'</DoQuery>




above query is executed successfully. Data is also updated but cardNAme update with value 'jkl mno' . It should be updated with value 'jkł mno'.

I have also try with CDATA (<DoQuery><![CDATA[Update OCRD set CardName='jkł mno' where Cardcode = 'ABCD']]></DoQuery>) but same result.

Please suggest how to update a table data with ASCI character using DI Server.


Surajit Kundu