mibheenick
New member
- Joined
- Dec 22, 2010
- Messages
- 1
- Programming Experience
- 1-3
Hi everyone
Well i've got a lil situation here. I have to read an XML file from disk and then send the content in a table which contains an Xml field. My issue is that my XML file contains characters like "é", "è", ... and these prevent me from inserting the content of the file in my table.
I am including the code I am using. Ideally i just want to replace the characters "é", "è" by "e". I thank you people in advance for your help.
INSERT INTO XmlImportTest(xmlFileName, xml_data)
SELECT ' + 'C:\Temp\ORDER1.xml' + ', xmlData
FROM(SELECT * FROM OPENROWSET (BULK ' + 'C:\Temp\ORDER1.xml' + ' , SINGLE_BLOB) AS XMLDATA) AS FileImport (XMLDATA)
Well i've got a lil situation here. I have to read an XML file from disk and then send the content in a table which contains an Xml field. My issue is that my XML file contains characters like "é", "è", ... and these prevent me from inserting the content of the file in my table.
I am including the code I am using. Ideally i just want to replace the characters "é", "è" by "e". I thank you people in advance for your help.
INSERT INTO XmlImportTest(xmlFileName, xml_data)
SELECT ' + 'C:\Temp\ORDER1.xml' + ', xmlData
FROM(SELECT * FROM OPENROWSET (BULK ' + 'C:\Temp\ORDER1.xml' + ' , SINGLE_BLOB) AS XMLDATA) AS FileImport (XMLDATA)
