I have setup flexsearh on my site and everything works great, but it seems to be case-sensitive. Is there a setting I am missing to make it not case sensitive, or am I just setting it up wrong. Any help would be appreciated.
This is the snippet call I am using:
[!FlexSearchForm? &FSF_showResults=`0` &FSF_landing=`27`!]
Hi,
usually it´s not case-sensitive. How does your "landing site" (id 27) look like? Imho it should have another call for the flexform snippet:
[!FlexSearchForm?FSF_showResults=`1` &FSF_showForm=`0`!]
Did you try the "partial" search? set this in the snippet:
$searchStyle = ’partial’;
I do have the search style set to partial, so that isn’t it. Anything else to try? Thanks for the help.
If you have it set to partial then I’d try relevance. This single config option makes the snippet handle searches in a very different way. Generally speaking, I would recommend using relevance. The primary drawback with relevance is that you can’t do searches on words 3 letters long or less (MySQL limitation incidentally). But the results tend to be fewer and better. Usually. (See disclaimer below.)
Standard Disclaimer
I could be totally wrong.
Well, I tried using relevance, and that did not work as well. Could there be a setting in my php setup causing this????
-
MODX Staff
- 10,725 Posts
In fact, since the search form uses full-text search capabilities in MySQL, this is completely dependent on the MySQL environment, and the case-sensitivity in particular is related to the collation sequence on the fields involved in the full-text index on the site_content table. So it really depends on the default collation sequence your MySQL instance used when creating the initial tables during installation.
Thanks for the info. I looked at the table and I have the collation set to utf8_bin. Can you suggest a better one to use. I don’t know a whole lot about collation types.
