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.