Forums / Cotonti / Extensions / Search will only find capitalised words?

musashi9
#1 2012-10-01 13:05

When I search for pages on my site for example I have 15 pages called Pagex and I search using the search plug in for pagex I get no results, I have to type Pagex with a capital P.

Is there a way to get a good result regardless of the capital letter?

Trustmaster
#2 2012-10-01 13:44

It has something to do with your MySQL settings because search is case insensitive by default. It is explained here. Check your tables and columns collations in phpMyAdmin and make sure they have _ci postfix rather than _cs or _bin. Cotonti uses utf8_unicode_ci collation by default.

May the Source be with you!
musashi9
#3 2012-10-02 00:41

All have utf8_unicode_ci and I still have the problem

This post was edited by musashi9 (2012-10-03 00:30, 11 years ago)