match-against with ä to ae (and vice versa) conversion
Posted by: stefan
Date: July 06, 2005 08:23PM

hello all,

a project of mine needs to full-text search our database (short texts), and i see that "match-against" would fit it quite well (a like "%search%" would do it too).

the question is: the umlauts in german can also be written in a different manner, e.g. "ä" can also be written as "ae", and "ö" as "oe". when a user searches, and theres an umlaut in the query, it should find its substitution too. thats especially needed with names, where you often don't know if its an unlaut or its subsitution.

can i handle this with collations? when yes, how? when not, does anybody know an alternative or a nice workaround? (true, i could parse the search-string in the backend (php) and add the words in question to the string, but thats not so really elegant and at least it distorts the ranking of match-against).

thanks in advance,

Options: ReplyQuote

Written By
match-against with ä to ae (and vice versa) conversion
July 06, 2005 08:23PM

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.