Re: Inserting RETURN character

I think you have to prepare the statement with the parameter set to '?' and then use the setString() method on the prepared statement to set the text. Assuming you are using Java/JDBC. Best Regards, Octav Aurelio wrote: > Hello, I am having problems while inserting in a Informix database a > string catched from a form field (a textarea) with several lines. I > think the problem is the return character. How can I'insert it? > The exception is: java.sql.SQLException: An illegal character has been > found in the statement. > > Thank you -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com