How about using a view? This way it looks like a normal table on
the outside, and it's all DB. Can you define a rule or some such to
allow updating through the view? (It still makes constructs such as
LIKE "%something" oddball.)
Tom Kochanowicz wrote:
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
___________________________________________________________________________
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
