-
- 786 Posts
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`!]
-
- 1,039 Posts
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`!]
-
- 1,039 Posts
Did you try the "partial" search? set this in the snippet:
$searchStyle = ’partial’;
-
- 786 Posts
I do have the search style set to partial, so that isn’t it. Anything else to try? Thanks for the help.
-
- 302 Posts
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.
-
- 786 Posts
Well, I tried using relevance, and that did not work as well. Could there be a setting in my php setup causing this????
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.
-
- 786 Posts
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.