List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 14 2003 6:43pm
Subject:Re: indexing a blob
View as plain text  
At 10:10 +0200 1/14/03, Octavian Rasnita wrote:
>Can I index just a smaller number of characters from a field even though the
>field has more?
>Will this make MySQL to index that field faster?

For BLOB and TEXT columns, you *must* in fact index just a certain number
of bytes (maximum of 255 bytes).  You cannot index BLOB or TEXT columns
without specifying a prefix length.
indexing a blobDavid T-G30 Dec
  • Re: indexing a blobJeremy Zawodny31 Dec
  • RE: indexing a blobJennifer Goodie31 Dec
  • Re: indexing a blobKeith C. Ivey31 Dec
  • Re: indexing a blobDavid T-G31 Dec
  • Re: indexing a blobBenjamin Pflugmann31 Dec
  • Re: indexing a blobOctavian Rasnita14 Jan
    • Re: indexing a blobZak Greant14 Jan
    • Re: indexing a blobPaul DuBois14 Jan
  • Re: indexing a blobOctavian Rasnita14 Jan