Problems creating full text index
Posted 30 October 2006 - 12:34 AM
I am trying to add a full-text search to my site but when I tried to create a full-text index in my db I got the message, "#1071 - Specified key was too long; max key length is 1000 bytes"
Can anyone tell me what this means and how to deal with it?
Any suggestions would be greatly appreciated.
Posted 30 October 2006 - 02:37 AM
Posted 31 October 2006 - 08:28 PM
imgID - int(
imgURL - varchar(100)
imgThbURL - varchar(100)
imgTitle - varchar(200)
imgCaption - varchar(2000)
and when I tried to index imgCaption alone or with other fields I got the error. I have spoken to my client and determined that I can safely set the imgCaption length to 400 and now the full text index is working.
Thanks for the links about key lengths. I am however still interested in how you would do a full-text index if you did need the field to be much larger.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users