Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Problem with character set/collation with XML

Author  Topic 

cornelius
Starting Member

11 Posts

Posted - 2008-11-10 : 10:36:17
Hi all.

We have a problem where we are saving an XML file textinside a table column (text 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. The program is written in Java, and MSSQL server 2005 (9.0.3282)

Can anyone direct me on where to look and what the problem may be?

Thank you.
   

- Advertisement -