UTL_SMTP with multibyte
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.