Special Characters in CSV file causing errors in sql query

Version 1
    This document was generated from CDN thread

    Created by: Mike Reilly on 23-03-2010 02:53:18 PM
    When doing a sql query to "insert" CMC codes, some of the descriptions that are contained in the .csv file have characters which are causing the "insert" query to error out. For example '09. Is there a doc which outlines the special characters that the informix database doesn't recognize? Is there a way to ignore those characters?

    Subject: RE: Special Characters in CSV file causing errors in sql query
    Replied by: David Staudt on 23-03-2010 11:09:59 PM
    Note that since you're submitting the SQL as part of an XML document, the SQL text itself must still be XML escaped.  Once AXL decodes the XML, you still must escape quotes for SQL database.  Looks like this page may be helpful:
     
    http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.sqls.doc/ids_sqs_1818.htm