Misses short words
Kezz - April 21, 2005 - 09:52
| Project: | SQL Search (Trip Search) |
| Version: | 4.7.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Kezz |
| Status: | closed |
Jump to:
Description
Hi
Is there any way to get trip_search to recognize shorter words?
It seems to cut off at 3 letters or less - we'd like to set this at 2 letters.
We have a tourist guide at http://copenhagen.expozed.net and certain short words, like 'bar' 'bus' or 'map' are important to our visitors, so we'd like them indexed.
thx in advance for any help on this one :)

#1
there is no minimum. works for me with 1 letter.
#2
Nope sorry - still get no results on words with 3 letters or less.
Try it for yourself at Copenhagen Expozed.
I'd love to know why this behaves differently on different sites though - we just installed it 'as is'
Getting curious now ;)
#3
Hi Kezz,
I have exactly the same issue. Working with Drupal 4.7. I need a 3 letters search working.
I have noticed that it works perfectly on your site. Congratulations! It is true that Trip Search is a fantastic module.
How did you fix that finally?
I know that this is an old post but thank you in advance for your answer.
#4
Actually this is to do with your MySQL settings. SQL Search relies on the MySQL Fulltext indexing system, and by default MySQL does not index words shorter than 4 characters. It is possible to change this to index shorter words (though I would be dubious about going down to one-word lengths). You can find the details of how to do this in the MySQL documentation, alternatively if you are using a hosting service you will probably have to ask your provider to do this.
#5
Thank you very much for your so prompt and efficient answer.
I will get into the mysql configuration and try to finetune this issue.
Thanks for the direct mysql documentation link. I appreciate your time.
Congratulations again for your module ;-)