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