Home » SQL & PL/SQL » SQL & PL/SQL » UTL_SMTP issue with Canadian French lanaguage (Oracle Applications)
UTL_SMTP issue with Canadian French lanaguage [message #426479] Thu, 15 October 2009 13:26 Go to next message
pasam.venkanna
Messages: 11
Registered: October 2009
Location: Hyderabad
Junior Member
Hi Gurus,
I am using UTL_SMTP package to send mails from Oracle Applications when an event occurs and it is working fine. But some of the characters are not displaying correctly in mail content.

English Version:
utl_smtp.write_data(mail_conn,UTL_tcp.CRLF||'For additional order information, Login to:');
French Version:
utl_smtp.write_raw_data(mail_conn, utl_raw.cast_to_raw(convert('Pour plus d'information sur cette commande, entrez sur:','UTF8')));

but we are getting output as 'Pour plus d�information sur cette commande, entrez sur' instead of 'Pour plus d'information sur cette commande, entrez sur:'

Please let me know your inputs..
Thanks in Advance..
Venkanna
Re: UTL_SMTP issue with Canadian French lanaguage [message #426480 is a reply to message #426479] Thu, 15 October 2009 13:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> But some of the characters are not displaying correctly in mail content.
The challenge is to determine if the source of the problem is with the sender or the receiver/client.

Do you have a binary editor to inspect the content of the message at the client independent of the email client s/w.

As you stated, problem may be only a data presentation issue.
Re: UTL_SMTP issue with Canadian French lanaguage [message #426502 is a reply to message #426479] Fri, 16 October 2009 00:55 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
To help test where the culprit lies (reader or sender), you can telnet to your SMTP-server and send the data you want manually. Then check how it arrives at your reader.
If you don't know how to manually feed your SMTP-server, google for SMTP telnet HELO
Previous Topic: No Data Found with insert
Next Topic: performance tuning / optimization (merged 3)
Goto Forum:
  


Current Time: Thu Feb 13 17:06:26 CST 2025