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

[former_member209771]

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 :

<?xml version="1.0" encoding="utf-16"?> <env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"> <env:Header>

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

</env:Header>

<env:Body>

<dis:ExecuteSQL xmlns:dis="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

[former_member209771 · Accepted solution]

Hi All,

I got my solution .I think it's a sql server related scenario. Update query working after modify the query as below format :

Update OCRD set CardName=N'jkł mno' where Cardcode = 'ABCD'

Thanks

Surajit Kundu