Multi-lingual serches
I am sure Oracle Text and the use of lexers might have a solution to the problem I have.
Requirement - Say I have a column that stores the last name of an individual. This last name, depending on the geography where it is entered from, could contain Latin, German or Arabic character sets. The entry part is fine. So, Smith could be entered in all three character sets - 3 records say. Now the query function on this column should return data entered in all languages regardless of the current language and keyboard mapping chosen by the user. Is this possible using Oracle Text OOTB?