Is there a standard function (in 11.2) to convert special characters to the HTML equivalent? I've been searching for this function, but haven't found one yet.
I do not mean a URL escape:
SQL> select utl_url.escape('é') coded from dual;
CODED
----------
%BF
but a function that would return
SQL> select some_function('é') coded from dual;
CODED
----------
é
I need to send html emails using a mail package that uses utl_smtp.data. This strips the special characters.
I know this can be solved by using utl_smtp.write_raw_data. Since it is a standard mail package, my options are limited in modifying that package. Instead of modifying the package, I am looking into converting the email html text to encoded html first.
Thanks
Ino