Hi,
I am trying to write a procedure that generates email addresses from people's names.
There are a number of people with non-English characters in their names such as umlauts, fadas, graves etc. and I am wondering if there is a handy way to convert these to their English equivalent (e.g. convert 'á' to 'a' or 'ß' to 'ss')?
I tried using UTL_RAW.CAST_TO_VARCHAR2(NLSSORT(:the_name, 'nls_sort=binary_ai')) which seemed to work fine except that it also converts string to lower case.
Any suggestions would be much appreciated.
G'Joob