Hi, This may sounds crazy, but have you consider using 4 varchar(255) breaking the 1000 string into 4 parts, and the breaking position should be at around each of the 250 mark which is a space. Doing so, you still could still query these 4 four fields together
HTH Best Regards, Lim Yong How Software Engineer Ryeson Security International 180B Bencoolen Street #10-01/02 The Bencoolen Singapore 189648 www.ryeson.com <http://www.ryeson.com> ____________________________________________________________________________ ________________________ The information contained in this e-mail message is intended only for the use of the person or entity to whom it is addressed and may contain information that is CONFIDENTIAL and may be LEGALLY PRIVILEGED and exempt from disclosure under applicable laws. If you read this message and are not the addressee you are notified that use, dissemination, distribution, or reproduction of this message is prohibited. If you have received this message in error, please notify us immediately and delete the original message. ____________________________________________________________________________ __________________ -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Kochanowicz Sent: Tuesday, 24 December, 2002 8:26 AM To: [EMAIL PROTECTED] Subject: Re: Text Area & Limit ed datbase fields. 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 ___________________________________________________________________________ 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
