You can't use that column type as an index because it's variable length.
Make it a varchar or something that's definite to index it.
-Micah
On 02/09/2007 03:56 PM, John Pillion wrote:
I am trying to set an index on a field in my table, but am getting the
following error:
BLOB column
as to what type to use
that wouldn't be variable length, but be able to store strings/values of
that size?
Thanks!
John
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 6:29 PM
To: John Pillion
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] indexing
to use
that wouldn't be variable length, but be able to store strings/values of
that size?
Thanks!
John
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 6:29 PM
To: John Pillion
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] indexing