Skip navigation links

MySQL Forums :: Table Space :: Indexes on Text Fields


Advanced Search

Indexes on Text Fields
Posted by: Valentine Andreev ()
Date: November 28, 2010 05:49AM

I'm not sure if it's the correct forum, but I could find nothing else.

The thing is, when I try to create an index on a field of a string type, I sometimes get this error:

#1170 - BLOB/TEXT column '(...)' used in key specification without a key length

What's that? Is there any way to avoid it?

Options: ReplyQuote


Subject Views Written By Posted
Indexes on Text Fields 1965 Valentine Andreev 11/28/2010 05:49AM
Re: Indexes on Text Fields 1060 Rick James 11/29/2010 09:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.