none
SQL Adapter inserting XML escape characters RRS feed

  • Question

  • Hi,
    I am trying to insert data from a flat file to a SQL 2005 database text field.  However, when there is a ' in the text it is being inserted as &#39 from the XML.  Is there a way to get this to insert to the database field correctly as a '
    Thanks in advance
    Chris

    Wednesday, January 14, 2009 3:41 PM

Answers

  • 1) You should be able to pass single quote as is
    2) The XMl characters like < can be inserted using their respective escape sequences &lt;


    Abhinav
    • Marked as answer by edhickey Friday, January 30, 2009 12:12 AM
    Thursday, January 15, 2009 6:07 AM

All replies

  • 1) You should be able to pass single quote as is
    2) The XMl characters like < can be inserted using their respective escape sequences &lt;


    Abhinav
    • Marked as answer by edhickey Friday, January 30, 2009 12:12 AM
    Thursday, January 15, 2009 6:07 AM
  • It might be the encoding of your flat file, what do you have it set at?
    Friday, January 16, 2009 6:46 AM