Storing HTML in database

[Robert Misior]

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, e-mail: <mailto:struts-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@;jakarta.apache.org>