Prem, I copied the code as is and executed it after updating mail server, recipient id and msg variable. No luck. Still the same. Data column value retrieved from db: ****************************** Quality 原材料リジェクト And following is what the mail reported: ******************************* admin@xxxxxxxx suneet.madhok@xxxxxxxxx Subject: DBA Alert MIME-version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Quality ???????? <----- question mark coming instead of original text. Thnx Suneet -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Prem Khanna J Sent: March 12, 2004 1:57 PM To: oracle-l@xxxxxxxxxxxxx Cc: suneet.madhok@xxxxxxxxx Subject: RE: HOW TO: Mail containing multilingual text from database Hi Suneet , use the script below . it works for me in 9iR2. Note this line --> UTL_SMTP.WRITE_RAW_DATA Regards, Prem. ------------------------- 8< ------------------------- 8< ------------------------- 8< ------------------------- 8< create or replace procedure send_email as mailhost varchar2(100) := '111.222.333.444'; mail_conn utl_smtp.connection; dates varchar2(100) := 'Date: ' || to_char( sysdate, 'dd-Mon-yyyy HH24:MI' ); sender varchar2(100) := 'From: "DBA" <admin@xxxxxxxx>'; recipient varchar2(100) := 'To: "You" <dba@xxxxxxxx>'; subj varchar2(100) := 'Subject: DBA Alert '; mimev varchar2(100) := 'MIME-version: 1.0'; ctype varchar2(100) := 'Content-Type: text/plain; charset=utf-8'; cenc varchar2(100) := 'Content-Transfer-Encoding: 8bit'; msg varchar2(2000) ; begin msg := ' your multilingual email body here ' ; mail_conn :=utl_smtp.open_connection(mailhost,25); utl_smtp.helo(mail_conn,mailhost); utl_smtp.mail(mail_conn,sender); utl_smtp.rcpt(mail_conn,recipient); utl_smtp.open_data(mail_conn); utl_smtp.write_data(mail_conn,dates || utl_tcp.CRLF); utl_smtp.write_data(mail_conn,sender || utl_tcp.CRLF); utl_smtp.write_data(mail_conn,recipient || utl_tcp.CRLF); utl_smtp.write_data(mail_conn,subj || utl_tcp.CRLF); utl_smtp.write_data(mail_conn,mimev || utl_tcp.CRLF); utl_smtp.write_data(mail_conn,ctype || utl_tcp.CRLF); utl_smtp.write_data(mail_conn,cenc || utl_tcp.CRLF); utl_smtp.write_raw_data(mail_conn, utl_raw.cast_to_raw(utl_tcp.CRLF|| msg || utl_tcp.CRLF)); utl_smtp.close_data(mail_conn); utl_smtp.quit(mail_conn); end; ------------------------- 8< ------------------------- 8< ------------------------- 8< ------------------------- 8< ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------