I am actually setting up a wizard function on an oracle database (this wasn´t part of the job description:-)). But I am just working with a kind of Wizard interface, so I am not coding anything.
The wizard will filter out specific keywords of database content and applies specific rules to this content. Anyway, many words in the content contain special letters, and the wizard rules won´t consider these words, which has a very negative impact on the Wizard quality.
I got the advice to replace special letters in the query with a variable that stands for any character. Example (the keyword should be "coopération"):
(coop[!e]ration) -> where [!e] would stand for any letter expect e.
The rule itself does not work, but I am asking myself (and now you) if such `character variables´ could be an option and how they work. In an ideal case, the variable would even replace a character row, because the special characters are possibly coded into several characters.