Thread

I have a client that needs to have state abbreviations (AZ, WA, NC) searchable, which doesn’t work with EE, since there is a search limit of 3 characters for MySQL. I read this thread (http://ellislab.com/forums/viewthread/187656/), in which someone else had this issue. I’m wondering if anyone has any solutions for this limitation. I’ve read solutions online in similar situations where a supplemental “_” character was added to a search to meet the minimum requirements to search the DB. I’m surprised this hasn’t come up before, since it seems like a pretty basic requirement. Perhaps I’m missing something.

Thanks!

Hi Aaren Hofferth,

i think, there is no way for setting limit of search characters from CP.

you can overcome from this :

1) set the character limit by the setting the value of $min_length in mod.search.php
2) look into the file system\expressionengine\config\stopwords.php, if there is any word being used as search term or as “common search words” which you are using for search.

I hope this would help you.

Best Regards,

All the threads I’ve read said it wasn’t possible to do that, so I didn’t bother, however, that solution seems to work pretty well, thanks ! 😊

You would probably need to change your SQL config to allow search for less than 3 characters, by default on most servers this is set to 3 characters or more