Because to my knowledge the limitation of a TEXT field is 64K. I need to store entire documents in the database which far exceed the 64K limitation. Given that criteria, the only option is to use blob fields which have an upper limit of roughly 4GB.
-----Original Message----- From: Justin French [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:08 AM To: David Buerer Subject: Re: [PHP] Keyword & exact phrase search Why would you have text in blob fields????????????????? Justin French on 16/08/02 1:25 AM, David Buerer ([EMAIL PROTECTED]) wrote: > I'd like to agree. But i've speant a lot of time investigating, learning, > and expirimenting with Full Text search and what I've found is that first, > full text does not always return the right results and second and perhaps > more important in my situation is that full text search doesn't work on BLOB > fields. > > > > -----Original Message----- > From: Justin French [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 8:37 AM > To: David Buerer; '[EMAIL PROTECTED]' > Subject: Re: [PHP] Keyword & exact phrase search > > > I only just started getting into this, but it seems that a LOT of the work > is done for you with MySQL's FULLTEXT stuff.... Check it out in the MySQL > manual. > > Justin French > > > on 16/08/02 12:59 AM, David Buerer ([EMAIL PROTECTED]) wrote: > >> Has anyone bumped into or written a set of good searching routines? I need >> to search across one,two, or three fields in an MySQL database in either >> exact phrase (easy) or keyword with relavence (difficult.) I'm thinking >> something like a google/yahoo style search. I've tried MySQL full text >> searches, but the results it returns seem to be just a little to broad and >> you end up with a bunch of irrelevant results. >> >> With respect to the database size that I'm searching in, right now it's >> about 20MB but I'm guessing that within the next 24 months it will be up >> around 2GB. The first field I'm searching in is a CHAR(255) field. The >> second field is a small blob and usually is only about 1 paragraph of > text. >> The thrid field is an entire HTML document and can be many many pages > long. >> >> Any help is appreciated, >> David >> >> >> > >