|
Hello All, I am currently importing datarows into a sql 2000 data_base_. when I use my stored procedure which contains sp__xml__preparedocument... and FROM OPEN_xml_, I get the error stated above in the subject heading. In reading other websites I have found that the error above: An invalid character was found in text content. You will get this error message if a character in the _xml_ document does not match the encoding attribute. Normally you will get this error message if your _xml_ document contains foreign characters, and the file was saved with a single-byte encoding editor like Notepad, and no encoding attribute was specified. The actual error is: Server: Msg 6603, Level 16, State 1, Procedure sp__xml__preparedocument, Line 15 _xml_ parsing error: An Invalid character was found in text content. _base_d on what I found on the other webisite, the only foreign character in my data the È in ARKTX= XXX CRÈME 1x20 KG . Is there anyway to encode this character so I do not get a parsing error? Thank you in advance Eric
|