Serendipity Forums

Hello,

i'am using s9y 0.91 with a MySql 4.0.15 database.

Quick Search function work well, except* if the searched term is preceded by a ' (quotation mark).

For example, i have a word (introspection) twice in my blog (2 separate entries).
the first is in a sentence as : ..... mon introspection....
the second is in another sentence as : ... un travail d'introspection, hors ....

Doing a search on the word introspection , the search result is 1 matching entry (the first)
Doing a search on the word 'introspection , the search result is 1 matching entry (the second).

How can i do to get the two entries with the first search term ?

I've had a look to the serendipity_searchEntries function in the functions_entries.inc.php file.
I saw (line 526 and following) that the mysql database type is not processed with SQL statement, but with regular expressions.
Has anyone made the adaptation for the mysql database type ? (perhaps i just say a big 'error', sorry).

Any help will be appreciated.

* i've not tested all possibilities; perhaps is there others limitations

thanks
Edwige

The problem is that we are using the MySQL internal fulltext search, which does not recognize "'" as being a part of a word, so the results for those words can be inaccurate.

I'm afraid I'm currently not so well into the MySQL MATCH AGAINST syntax and how to modify their search...maybe you can just debug the SQL query that is used (you alread found the right place) and ask on a MySQL specific forum on how to match against special characters?

Best regards,
Garvin