Skip to Content
0
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 :

http://schemas.xmlsoap.org/soap/envelope/">

<SessionID>74111B1D-2A9A-40BD-93DF-6E194B42C9</SessionID>

</env:Header>

<env:Body>

http://www.sap.com/SBO/DIS">

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

</dis:ExecuteSQL>

</env:Body>

</env:Envelope>

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.

Thanks

Surajit Kundu