Hi all.
We have a problem where we are saving an XML file data inside a table column (varchar column) and when we query that data and compare it to the original XML, the comparison returns false.
This process works just fine in tens of other MSSQL servers. That is why we'rs suspecting this might be a character set problem.
The collation in this server is the same as in all other servers where this process was successful. The default language of both the server and the OS is English-united states, as in all other servers.
Can anyone direct me on where to look and what the problem may be?
Thank you
Nili