Hello,

I'm looking for a good approach of storing HTML in mysql database (field
type is text).  Currently I'm converting any character other then a
number or  alpha character to it's ASCII value before the table is
updated.  So far this  is working fine  except extra overhead and
storage space.  The main reason why I'm doing it this way is  because I
had problems with the sql statement being truncated  at the first
appearance of a  ' in the HTML.
Would searching for ' and replacing them with \' be a bather solution
or would using PreparedStatement fix this problem with '?

Thanks for any suggestions,
Robert

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com

Reply via email to