August 28, 2003 at 3:50 pm
When using FOR XML RAW...
I was wondering why SQL Server would replace the character "<" with "<" but it does NOT replace other invalid characters in XML. For example, I have a table of names. One name is Muñoz. When I load the return of FOR XML RAW, I get a parser error stating An Invalid character was found in text content. How would I go about replacing all of these invalid characters that SQL Server does not replace?
September 1, 2003 at 12:00 pm
This was removed by the editor as SPAM
September 1, 2003 at 7:36 pm
Hi there
This is strange. FOR XML returns data in UTF-8 format, so this shouldnt be an issue. Then again, it could also be:
a) the ADO objects being used and how you are streaming the data
b) the MS DOM you are using and its compatibilities/properties
c) are you pre-dumping into varchar/text fields before the return? (possible character conversion)
I would open up an adodb stream obj and dump the xml to a flat file to double check.
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply