| McGeeky 2006-10-28, 7:30 pm |
| Hi. I am running in to collation issues when using openxml and would
appreciate help in understanding why these issues are occuring.
We have a database configured with a default collation setting of
Latin1_General_CI_AS
.
A stored procedure opens up an XML document and joins it to a table in the
database. SQL Server refused to create the stored procedure because of a
collation conflict. The table column being joined upon has a collation
setting of SQL_Latin1_General_C
P1_CI_AS. I have not specified a collation
setting when opening the XML document.
Does SQLXML open XML documents using the database default collation setting?
Is that why I am getting these problems?
What are the resolutions to this issue? I am thinking I would need to either
change the column to match the database default, change the database default
to match the column, or do a specific cast on the XML to the table column's
collation.
Thanks!
--
McGeeky
http://mcgeeky.blogspot.com
|