Correct, according to the mySQL documentation the text and blob are the
same except if you do a search for text in a blob it is case sensitive
whereas the text is not case sensitive in a TEXT area. This is not the
problem however. The difference between TINY TEXT (or TINY BLOB) and MINI
TEXT (I'm approximating here) is 255 bytes and 16K bytes respectfully.
Unlike varchar, TEXT and BLOB fields do not truncate the additional
allocated spaces, thus a lot of space is wasted and searches would take
longer.
What I am trying to do is get around the limitations of the database and
find a way to maximize performance by scripting something in a servlet or
JSP page that will allow a user to insert a maximum of 1000 into a database
field without sacrificing performance and disk space. Perhaps the BLOB and
TEXT fields are as good as it gets in mySQL. I know M$SQL has a varchar of
1000 chars, but I have champagne taste on a beer budget so that is out of
the question.
TK
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
Christian Kurze
Sent: Sunday, December 22, 2002 9:14 AM
To: [EMAIL PROTECTED]
Subject: Re: Text Area & Limit ed datbase fields.
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
___________________________________________________________________________
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
