PL/SQL (MOSC)

MOSC Banner

UTL_SMTP with multibyte

in PL/SQL (MOSC) 4 commentsAnswered

Oracle 19c, windows

I have a procedure that I use to test utl_smtp package. I have 2 options

If I use 0 in my call, I put the text in variables any other value

select from a table.

if vtype = 0 then 

 lv_subject := 'My Subject ÅÄÖ';

 lv_message := 'My Message åäö';

 else

  select h,b into lv_subject,lv_message from mail_test_tab where no = 1;

 end if;

My problem is that when I select from the table my ÅÖÄ characyers are not presented

properly, but they are if I assign the text directly to the variables.

Database has we8mswin1252 character set, column is varchar2.

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