Oracle SQL has some sophisticated functions to reduce e.g. accented characters to their base letter.
A good example is the city of Łódź, which will be reduced to base letters in a function call like this:
SQL> select UTL_I18N.UNESCAPE_REFERENCE('Łódź') data from dual;
DATA
--------------------------------------------------------------------------------
Lódz
SQL>
(my db charset is WE8MSWIN1252, so "ó" goes "through")
My questions:
- Where can I look up the definitions (lookup tables) for these replacements?
- Can I customize them?
btw. I don't understand why theses translations do not work in statements like this:
SQL> select convert('Łódź','WE8MSWIN1252') from dual;
CONV
----
ód
SQL> select convert('Łódź','US7ASCII') from dual;
CONV
----
od
SQL>
I went through "
Linguistic Sorting and String Searching" in the Database Globalization Support Guide, but did not really get an anwer on this.
Thanks, Tom