indexing error - key length not specified

From: Date: Fri, 09 Feb 2007 23:56:59 +0000
Subject: indexing error - key length not specified
Groups: php.db 
Request: Send a blank email to php-db+get-43052@lists.php.net to get a copy of this message
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 though, based on the error, was I needed to set a length to the field - but it won't accept/store any length I give it (because it's a variable length?) I'm using mysql on from 1and1 (hosting provider), though I don't know what version they're running .. any thoughts? As an alternative, how much less efficient would it be to do a ".LIKE '%mystring%'" versus a MATCH..?

« previous php.db (#43052) next »