MySQL Forums :: Table Space :: Indexes on Text Fields
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?
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?
| 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.
© 2013, Oracle Corporation and/or its affiliates