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:
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:
<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:
<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..