OraFAQ Forum: Japanese » Problem with UTL_SMTP for Japanese characters

Home » Non-English Forums » Japanese » Problem with UTL_SMTP for Japanese characters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with UTL_SMTP for Japanese characters [message #42761]

Wed, 07 May 2003 04:54

Kiran G Kumar
Messages: 5
Registered: April 2003

Junior Member

Hello,

In our project, we need to send the emails in Japanese Language. I am using UTL_SMTP package to send the emails. I am able to send the email's BODY in Japanese, but I am NOT ABLE to send EMAIL SUBJECT in Japanese. It shows '??????' marks in SUBJECT for japanese characters.

Here I am giving the code that I have written for that.

mesg:=
'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || utl_tcp.CRLF ||
'From: ' || from_name || utl_tcp.CRLF ||
'Subject: ' || subject || utl_tcp.CRLF ||
'To: ' || to_name || utl_tcp.CRLF ||
'Mime-Version: 1.0' || utl_tcp.CRLF ||
'Content-Type: text/html; charset=UTF-8'||utl_tcp.CRLF;

utl_smtp.write_data ( conn, mesg );

utl_smtp.write_raw_data(conn, utl_raw.cast_to_raw(UTL_TCP.CRLF||message || utl_tcp.CRLF));

I am setting the charset (UTF-8) properly, It is reflecting only for EMAIL body but NOT the subject.

Any help in this regard is highly appreciated.

Thank You
Kiran

Report message to a moderator