[Explained] Search for a word accentuated - again

Found a bug? Tell us!!
Post Reply
Barberousse
Regular
Posts: 26
Joined: Sun Dec 30, 2007 8:07 pm

[Explained] Search for a word accentuated - again

Post 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.
Last edited by Barberousse on Wed Jul 09, 2008 10:02 am, edited 1 time in total.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Search for a word accentuated - again

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Barberousse
Regular
Posts: 26
Joined: Sun Dec 30, 2007 8:07 pm

Post 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.
Post Reply