Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sending Mail using utl_smtp special Chars üöä

390061Dec 1 2004 — edited Dec 3 2004
hi,
i want to send email using utl_smtp and this works good.
but now my problem. I want to send special Chars (e.g. öäüÖÄÜß).
the char set of the database is "WE8ISO8859P15" and running on a hpux machine.
my program works in follow steps :
1.) read the data from a table. In the table special chars correct.
2.) sending mail
utl_smtp.write_data(o_smtp, 'Content-Type: text/plain; charset="iso-8859-1"' || utl_tcp.CRLF);
utl_smtp.write_data(o_smtp, 'Content-Transfer-Encoding: quoted-printable' || utl_tcp.CRLF);
utl_smtp.write_data(o_smtp, utl_tcp.CRLF || in_Nachricht );
in_Nachricht is the message with the special chars

3.) looking into the message using outlook show ü=u,ä=a

What can i do to send the special char correct ?
Thank you for your help
CZ
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2004
Added on Dec 1 2004
4 comments
866 views