eric is right, there is a text type in mysql which is very useful. christian
> -----Original Message----- > From: A mailing list for discussion about Sun Microsystem's Java Servlet > API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Eric > Noriega > Sent: Sunday, December 22, 2002 10:41 AM > To: [EMAIL PROTECTED] > Subject: Re: Text Area & Limit ed datbase fields. > > > 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 > ___________________________________________________________________________ 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
