I want to make case-insensitive and preferbly "accent-insensitive"
searches. I.e. a user who searches for "HELENE" should find "Helene"
and preferably also "H<e'>l<e`>ne", where <e'> and <e`> are "e" with
grave and acute. (if these are available in the charset, of course.)
I note that this can be done with SELECT, but then I suppose an index
can't be used so the entire table must be searched. Or can the index
be built _with_ character translation? Or maybe the datatype could
somehow be defined so that all compares and indexing will be done with
a specified character translation?
Note that I know some SQL but not Oracle, it won't be my job to
implement this. I've just browsed the Oracle manuals a bit. Though
of course I can always ask a local Oracle guru to translate any
replies if they get too cryptic:-)
--
Regards,
Hallvard