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.
[Explained] Search for a word accentuated - again
-
- Regular
- Posts: 26
- Joined: Sun Dec 30, 2007 8:07 pm
[Explained] Search for a word accentuated - again
Last edited by Barberousse on Wed Jul 09, 2008 10:02 am, edited 1 time in total.
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Search for a word accentuated - again
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
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/
# 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/
-
- Regular
- Posts: 26
- Joined: Sun Dec 30, 2007 8:07 pm