Hi all, i have written a small procedure to send e-mail from my oracle database [oracle 9.2.0.3/win2k]. message := 'Date: ' || TO_CHAR( SYSDATE, 'DD-Mon-YYYY HH24:MI:SS' ) || utl_tcp.CRLF; message := message || 'From: ' || sender || utl_tcp.CRLF; message := message || 'Subject: ' || subject || utl_tcp.CRLF; message := message || 'To: ' || recipient || utl_tcp.CRLF; message := message || 'Mime-Version: 1.0' || utl_tcp.CRLF; message := message || 'Content-Type: text/plain; charset="ISO-2022-JP"'||utl_tcp.CRLF; message := message || '表領域名' || chr(9) || '空き領域 (MB)' || utl_tcp.CRLF; # JAPANESE CHARACTERS ARE 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, message); utl_smtp.close_data(mail_conn); utl_smtp.quit(mail_conn); the japanese characters come out as ??? in the e-mail, whereas english characters work fine. what's wrong with my code ? Can someone help me ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
