Home » Non-English Forums » Japanese » Problem with UTL_SMTP for Japanese characters
Problem with UTL_SMTP for Japanese characters [message #42761] Wed, 07 May 2003 04:54 Go to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Alignment of the report output containing Japanse Characters
Goto Forum:
  


Current Time: Fri Apr 19 20:47:41 CDT 2024