PreparedStatements of course.
> -----Original Message----- > From: A mailing list about Java Server Pages specification > and reference [mailto:JSP-INTEREST@;JAVA.SUN.COM] On Behalf Of > Robert Misior > Sent: dinsdag 22 oktober 2002 16:08 > To: [EMAIL PROTECTED] > Subject: Storing HTML in database > > > 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 =========================================================================== 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
