XML parsing, illegal xml character

Asked Mar 07 '16 at 22:46

Active Mar 08 '16 at 15:18

Viewed 569 times

I have created a fairly large procedure importing thousands of xml files. The procedure runs smoothly until I hit a file that contains an illegal xml character. This character appears to resemble the female symbol.I was unable to paste it to the body of this question.

Below is my basic code to read an xml file. When the specific file is run, I get:

Msg 9420, lvl 16, state 1, line 5. XML parsing: line 1800, character 150, illegal xml character. Encoding is in ANSI

Declare @xml xml
select @xml = T
from OPENROWSET (BULK 'C:\Path', SINGLE_BLOB as Transactions (T)

Again the code wont read the file. Has anyone ever experienced this symbol and how can it be systematically erased/replaced?

edited Mar 08 '16 at 15:18

asked Mar 07 '16 at 22:46

Drew S

2

Is the troublesome character anywhere on this [list](https://dev.w3.org/html5/html-author/charref)? – Parfait Mar 08 '16 at 01:03
try to switch to a UTF encoding, rather than ANSI – Daniele Mar 08 '16 at 15:02
@Parfait it maybe be the female symbol. (&female) – Drew S Mar 08 '16 at 15:16
If I were to try and replace the female symbol out of my xml file as I am import it with the openrowset, what would be the correct syntax? – Drew S Mar 08 '16 at 15:31
See how to replace text in blob: http://stackoverflow.com/questions/16337814/replacing-text-in-an-blob-column – Parfait Mar 08 '16 at 17:34

XML parsing, illegal xml character

0 Answers0

Linked