PL/SQL (MOSC)

MOSC Banner

Special characters not showing correctly in email

edited Mar 6, 2013 10:38PM in PL/SQL (MOSC) 6 commentsAnswered
Hi,
I am sending email and it is not showing special characters to recipient of email. I am using

utl_smtp.write_data(objConnection,
'Subject: =?UTF-8?Q?' || utl_raw.cast_to_varchar2(utl_encode.quoted_printable_encode(utl_raw.cast_to_raw(sub))) || '?=' || utl_tcp.crlf);

Sub= Test ä

What receiver see is Test �.

thanks,

7Z


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center