I have xml document with sql query that get results from SQL Server 2000, data returned can contain verious languages -Russian in my case- when i access the xml document directly from within IE it returns the results fine with Russian data encoded correctly.
Now i want to use ADO Stream object to access and execute the same xml document, the Russian data returned as question marks (?).
I tried to set the Charset proprty of Stream object to many values, including UTF-16, ISO-8859-1, Windows-1251 ... but nothing work, i tried also to set enocding property of the xml document to same values above, also same problem.
What should i do? also if database contains Indian or Japanese data, whats the solution?
Thanx in advance.