Hi All!

I tried to execute following T-SQL:


DECLARE @hdoc int
DECLARE @doc varchar(1000)
SET @doc ='
<ROOT>
<Customer CustomerID="LILAS" ContactName="Carlos Gönzlez"/>
</ROOT>'
EXEC sp_xml_preparedocument @hdoc OUTPUT, @doc
EXEC sp_xml_removedocument @hdoc

The Problem is that there is an spectial Sign in the XmlString(Gönzlez) -> sp_xml_preparedocument throws an exception that there is an invalid Sign.

Has anyone a Solution ??

Thanks Peda