Good Idea, but mySQL will not support views until version 5.0. or until someone helps finance it.
TK -----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 6:32 PM To: [EMAIL PROTECTED] Subject: Re: Text Area & Limit ed datbase fields. 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 ___________________________________________________________________________ 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
