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 next 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
Re: Problem with UTL_SMTP for Japanese characters [message #46145 is a reply to message #42761] Thu, 13 May 2004 01:31 Go to previous messageGo to next message
pornchai
Messages: 1
Registered: May 2004
Junior Member
I have a problem same with you. If who can solve this problem, please sent solution to me. thank you
Re: Problem with UTL_SMTP for Japanese characters [message #501524 is a reply to message #42761] Tue, 29 March 2011 12:26 Go to previous messageGo to next message
jayapraksh
Messages: 3
Registered: January 2009
Location: pune
Junior Member

If any one have the solution please provide .. i am facing the same issue but in the Canadian French lang..

Re: Problem with UTL_SMTP for Japanese characters [message #531159 is a reply to message #42761] Mon, 14 November 2011 03:28 Go to previous message
aallan
Messages: 150
Registered: October 2011
Senior Member
hi dears;
any solution for characters in utl_mail ???
i need a characters support arabic letters..
Thanks All.
Previous Topic: Alignment of the report output containing Japanse Characters
Goto Forum:
  


Current Time: Thu Mar 28 16:12:22 CDT 2024