Absolute UTL_SMTP Character encoding Frustration
431408Jan 8 2007 — edited Aug 2 2007I 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