Special characters in email from Oracle pl / sql

Question

I am trying to send an email using utl_smtp with Oracle, including Norwegian characters (å æ ø). The characters are saved and displayed correctly in the database otherwise, but are displayed as question marks in the letter.

My database character set WE8MSWIN1252

I tried different mime Content-Type headers in the email, including "text / plain; charset =" win-1252 ", this doesn't seem to help.

Answer 1

By default, smtp is 7 bits ascii (a kind of old tech :). You have to use UTL_SMTP.write_dataand the documentation :

(VARCHAR2), WRITE_DATA US7ASCII . , , US7ASCII "?" . 8BITMIME SMTP- EHLO , VARCHAR2 RAW UTL_RAW, RAW- WRITE_RAW_DATA.

OTN, , .