Not sure about mySQL, but in the Postgres manual they state that using a varchar(254) or a "text" field (text is unlimited in size) incurs no additional overhead. I think that mySQL has a text type, but again, I haven't the details.
Tom Kochanowicz wrote:
I am using a JSP/Servlet to capture data to be inserted into an mySQL database. The database has a maximum limit on varchar of 255 charaters. I need to have double that amount. I could use MEDIUM_BLOB but that is way too big. Is their a way to use one text area on my JSP and two varchar fields to insert the data into. I heard of other databases with this restriction. What is the most effective way to handle this problem? TK ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
