Home » Developer & Programmer » Forms » SEND EMAIL IN ARABIC LANGUAGE
icon7.gif  SEND EMAIL IN ARABIC LANGUAGE [message #358999] Thu, 13 November 2008 04:50 Go to next message
EL-SAYED
Messages: 17
Registered: July 2008
Junior Member
HI

i Just built form to send emails and it works well but
i Have a Problem in Sending an email in arabic Language that is
the litters transfer to ??????? .


can any one know why this happend ?

thanks ....
Re: SEND EMAIL IN ARABIC LANGUAGE [message #359138 is a reply to message #358999] Thu, 13 November 2008 19:04 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
It is probably associated with the 'NLS_LANG' setting in one of the programs.

Please search this forum and site for 'arab' and 'arabic'. You could try mixing that word with 'email' or 'mail' or the name of the email handler you are using or 'outlook'.

There is an 'Arabic' forum on this site and there is http://www.araboug.org/ib

David
icon12.gif  Re: SEND EMAIL IN ARABIC LANGUAGE [message #359446 is a reply to message #358999] Sun, 16 November 2008 06:33 Go to previous messageGo to next message
EL-SAYED
Messages: 17
Registered: July 2008
Junior Member
@ djmartin

Thank You
i'm already search throw this forum but didn't found the solve.

Re: SEND EMAIL IN ARABIC LANGUAGE [message #359447 is a reply to message #359446] Sun, 16 November 2008 07:30 Go to previous messageGo to next message
Frank Naude
Messages: 4589
Registered: April 1998
Senior Member
You need to add MIME headers to define the character encoding. Something like this:

Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Re: SEND EMAIL IN ARABIC LANGUAGE [message #359884 is a reply to message #358999] Tue, 18 November 2008 07:56 Go to previous messageGo to next message
EL-SAYED
Messages: 17
Registered: July 2008
Junior Member
@ Frank Naude

thank you very much

i try to add this code


utl_smtp.open_data(mail_conn); 
utl_smtp.write_data( mail_conn, 'MIME-version: 1.0');   
utl_smtp.write_data( mail_conn, 'Content-TYPE: text/plain; charset=Arabic(Windows)');   
utl_smtp.write_data( mail_conn, 'Content-Transfer-Encoding: 8bit');   
utl_smtp.write_raw_data(mail_conn, utl_raw.cast_to_raw(mesgUTL_TCP.CRLF));   
utl_smtp.close_data(mail_conn); 



but also the problem didn't solve.

Re: SEND EMAIL IN ARABIC LANGUAGE [message #359947 is a reply to message #359884] Tue, 18 November 2008 23:05 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
From OracleŽ Database, PL/SQL Packages and Types Reference, 10g Release 2 (10.2), B14258-01, June 2005
When the target SMTP server supports 8BITMIME extension, users of multibyte databases may convert their non-US7ASCII, multibyte VARCHAR2 data to RAW and use the WRITE_RAW_DATA subprogram to send multibyte data using 8-bit MIME encoding.

Try using 'WRITE_RAW_DATA'.

David
[EDITED by DJM: fix bad tag]

[Updated on: Tue, 18 November 2008 23:06]

Report message to a moderator

Previous Topic: Append Data
Next Topic: display one canvas in front of another
Goto Forum:
  


Current Time: Mon Feb 03 14:51:33 CST 2025