Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Absolute UTL_SMTP Character encoding Frustration

431408Jan 8 2007 — edited Aug 2 2007
I am using UTL_SMTP to send emails from my DB, it works great when i am sending Standard ACSII emails, but when I try to send arabic emails (windows-1256) which corresponds to my Database character encoding NLS_LANG value ARABIC_SAUDI ARABIA.AR8MSWIN1256 all arabic characters appear as question marks in my email even though i set Content-transfer-encoding to windows-1256 as shown below.



l_maicon :=utl_smtp.open_connection('domain',25);
utl_smtp.helo(l_maicon,'domain');
utl_smtp.mail(l_maicon,' from@domain.com');
utl_smtp.rcpt(l_maicon, to@domain.com);
utl_smtp.rcpt(l_maicon, to2@domain.com);

utl_smtp.data(l_maicon,
'Content-type:text/html; charset=windows-1256' || utl_tcp.crlf ||
'From: from@domain.com' || utl_tcp.crlf||
'To: ' || to@domain.com || ';' || to2@domain.com || utl_tcp.crlf ||
'Subject: Notification System: ' || utl_tcp.crlf ||
'هذه الرسالة بالعربية');
utl_smtp.quit(l_maicon);


I am wondering if anyone has been across a similar problem.

Thank you,
Hussam Galal
hussam.galal@gmail.com
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2007
Added on Jan 8 2007
12 comments
3,952 views