Oscar Usifer schrieb am 14.09.2009 um 17:14:33 (-0500): > > My input XML <entry></entry> values are containing '&' input symbols, > e.g. "...<entry>Texas A&M</entry>"
That's a syntax error in XML. The ampersand is special. It is used for entity references, built-in and user-defined, like < or , and also for numeric character references, like d. The correct version would use & to represent the ampersand: <entry>Texas A&M</entry> > which results in errors as follows. I am reading the XML input from a > SQL database, and thus appear as input CLOBs, so no specification is > being set on the input charset. The charset should be UTF-8, UTF-16 with a BOM, or contained in the XML declaration. > Any ideas how to resolve? Well, the data is broken. Garbage in, garbage out. Fix the process that writes garbage into the database. -- Michael Ludwig