Ampersand problem. Returning too many hits
Hi
I tried posting in Newbie forum, but no luck. Here goes!
I'm trying to make a search in Etomite CMS, but I'm having some problems with special chars. I think the Ampersand is the problem.
SELECT id, longtitle, pagetitle, description, content FROM `tocv_2_cv_dk`.martinguld_site_content WHERE MATCH (pagetitle, description, content) AGAINST ('gået') AND `tocv_2_cv_dk`.martinguld_site_content.published = 1 AND `tocv_2_cv_dk`.martinguld_site_content.searchable=1 AND `tocv_2_cv_dk`.martinguld_site_content.deleted=0;
I'm searching for "gået" (gået).
the tricky part is that it matches ALL "å" and not the entire string (gået).
The same goes for ø and æ
I should only get 6 hits, but actually I get 73 hits (all pages containing å)
What is wrong?
I tried escaping it and other things, but nothing works so far...
Subject
Views
Written By
Posted
Ampersand problem. Returning too many hits
4983
March 27, 2008 06:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.