PL/SQL (MOSC)

MOSC Banner

Sending mail with Swedish characters

in PL/SQL (MOSC) 4 commentsAnswered

Hello !

Trying to send an email having Swedish characters in subject and body, read in the documentation that I need to use raw format, since utl_smtp.write_data converts to us7ascii.

Built. the following test procedure and I get the mail, but Swedish characters are not seen.

Check plenty of examples for other multibyte languages but it seems it does not work for me.

Any ideas are appreciated, db is 19.14 on windows server 2016 , characterset is we8mswin1252

CREATE OR REPLACE PROCEDURE MAIL_TEST

IS

 lv_server VARCHAR2(255) := 'localhost';

 lv_rcpt  VARCHAR2(255) := 'test@test.com';

 lv_from  VARCHAR2(255) := 'smtpservice@test.com';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center