MySQL Forums
Forum List  »  Full-Text Search

Advanced Search
New Topic

Re: Problem with fulltext search using encoded german umlauts (strange behaviour of "MATCH(column) AGAINST ('keyword' IN BOOLEAN MODE)")
Posted by: Rick James
Date: April 22, 2010 08:30AM

What is the flow of the data?
Can you intercept the text before the editor INSERTs it in the database?
Can you install a TRIGGER to 'fix' the data as it is inserted?
Could a TRIGGER create a cleaned up copy in another column (or another table)?
Do you have a chance to make a pass over the data between insertion and FT search? (This pass could clean up the field, perhaps without needing a TRIGGER.)

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.