Page 1 of 1

[Explained] Search for a word accentuated - again

Posted: Tue Jul 08, 2008 4:56 pm
by Barberousse
Hello,

I already had a similar problem (see http://board.s9y.org/viewtopic.php?t=12012) which is resolved but an issue is still remaining: if I search for "Frédéric" on my blog (Serendipity 1.3.1, PHP 5.1.3, MySQL 5.0.45), I have 2 results, but none for "Gaétan" (this word is present on at least half of the entries, it's my son's name !).

My table uses the "utf8_unicode_ci" encoding scheme.

Any ideas?

Thank you.

Barberousse.

Re: Search for a word accentuated - again

Posted: Wed Jul 09, 2008 9:56 am
by garvinhicking
Hi!

MySQL does not return results for matches that occur in most of the entries. MySQL in this case thinks that the results cannot be proper because too many results are found.

You can circumvent that by either configuring the MySQL Daemon (not suggested in hosted environments) or by using the boolean search (search for "Gaetan" enclosed in quotes, that should trigger boolean search).

Regards,
Garvin

Posted: Wed Jul 09, 2008 10:00 am
by Barberousse
Hello,

You're right, "Gaétan" with quotes give me 17 results (that's not that much...) but I can't configure anything (hosted environment, as you said). At least, I have a clear explanation for that weird behavior.

Thank you.

Barberousse.