Hi everyone,
we are using fox as a DLL middletier to get data as XML from SQL Server 2000 to an IIS environment. We are runnung into encoding problems when we use characters like '€'. What we do is: we run a SQL Server sp that typically some "Select for xml auto" , which results in a recordset which we get back through ODBC. This recordset consists of 1 column with all the xml as text. This xml is parsed client side, and this is when we run into problems. The MS XML 3.0 can't seem to parse those special characters. It is obvious that this is caused by conflicting encoding settings. I've solved this by adding "encoding=windows-1252" to the xml header, and this works. Now i'm wondering why it should.

I've read that the default encoding in sql server is UCS-2 (or is this only true for nchar of nvarchar datatypes?), en that the xml parser assumes the xml to be UTF-8 (if not explicitly set). My question is: what is the encoding of my text data when i get it back from sql server? Does the ODBC connection convert it? How can i check?

regards,
derk schutte