[PHP-DB] indexing error - key length not specified

2007-02-09 Thread John Pillion
I am trying to set an index on a field in my table, but am getting the following error: BLOB column 'ReadBy' used in key specification without a key length The fieldtype is blob, though I get the same error whether blob or text, or the medium and long versions of each. My first

Re: [PHP-DB] indexing error - key length not specified

2007-02-09 Thread Micah Stevens
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

RE: [PHP-DB] indexing error - key length not specified

2007-02-09 Thread John
error - key length not specified 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

Re: [PHP-DB] indexing error - key length not specified

2007-02-09 Thread Micah Stevens
error - key length not specified 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