The data will be used to store information on pets (dogs, cats etc). The max number of characters is to be 1000. Their will be as many as 10000 records and searches will be performed using either a key field e.g. customer number or using a %LIKE% sql command. So it is simply a store and retrival type of operation. Perhaps I need to look at a database that supports varchar of 1000 characters rather then mySQL. We are running Linux so this will go beyond our low budget. Thanks for the reponces.
TK -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Will Hartung Sent: Monday, December 23, 2002 11:16 AM To: [EMAIL PROTECTED] Subject: Re: Text Area & Limit ed datbase fields. > 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? How is the data going to be used? What kind of operations are going to be performed on it? How many rows of data do you plan on storing? All of these can affect the final solution that you choose. Regards, Will Hartung ([EMAIL PROTECTED]) ___________________________________________________________________________ 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
