problems with searches for 'c#' and 'c++'
Hi guys,
I have created a parser for cv’s and am having problems retrieving records when searching using the keywords ‘c#’, or ‘c++’. I use a boolean full text search and if a cv contains the keyword it should be retrieved.
The query is…
Code:
SELECT cv.id, cv.candidate_id, MATCH (cv.cv_text) AGAINST ('C++') AS score FROM db.cv_test cv, fb.candidates_test c WHERE cv.candidate_id = c.id AND c.hide_from_search = 'N' AND c.active = 'Y' AND MATCH (cv.cv_text) AGAINST (CONVERT( _utf8 '+C++' USING latin1 ) IN BOOLEAN MODE) order by score desc
It is not a minimium letters problem as that is set to 2
But nothing is returned.
Any idea's / suggestions would be appreciated
Subject
Views
Written By
Posted
problems with searches for 'c#' and 'c++'
3591
February 06, 2006 03:49AM
2516
April 24, 2006 07:04AM
2410
July 05, 2006 01:50AM
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.