Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i create a Store proc. for access webservices, which work well,
but my problem is if data came in HINDI LANGUAGE,then store proc return "????" this...,

my store proc is:

SQL
Set @sUrl='XXX.asmx/EmployeePersoanlNicuidWise?nicuid='+'2';

Exec sp_OACreate 'MSXML2.ServerXMLHTTP', @obj OUT;
Exec sp_OAMethod @obj, 'Open', NULL, 'get',@sUrl,false
Exec sp_OAMethod @obj, 'send'
Exec sp_OAGetProperty @obj, 'responseText', @response OUT

 SET @xml = @response;
  select @xml



it return data like this:
XML
<MySampleTable diffgr:id="MySampleTable1" msdata:rowOrder="0">
       
       <NameHindi>???? ????</NameHindi>
       <DesignationID>426</DesignationID>
       <Gender>M</Gender>
       <FatherName>BABU SINGH</FatherName>
       <dob>1976-06-12T00:00:00-07:00</dob>
       <OfficeCode>1090</OfficeCode>
       <DesgAppointID>0</DesgAppointID>
       <ActiveFlag>A</ActiveFlag>
     </MySampleTable>


and the orignal data is:
XML
<NewDataSet xmlns="">
<MySampleTable diffgr:id="MySampleTable1" msdata:rowOrder="0">

<NameHindi>भंवर सिंह</NameHindi>
<DesignationID>426</DesignationID>
<Gender>M</Gender>
<FatherName>BABU SINGH</FatherName>
<dob>1976-06-12T00:00:00-07:00</dob>
<OfficeCode>1090</OfficeCode>
<DesgAppointID>0</DesgAppointID>
<ActiveFlag>A</ActiveFlag>
</MySampleTable>
</NewDataSet>




so plz help me,how i get orignal hindi value..
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900