Sending email that contains Hebrew characters with UTL_SMTP returns question marks
Hi,
I am using UTL_SMTP for sending emails from my databases. When the text contains characters of Hebrew the email arrives with '?' marks instead of Hebrew.
I searched for solution to this issue and I didn't found any relevant answer.
In the documentation of UTL_SMTP I found the following description:
Text (<span style="font-size: 10.0pt; color: black; background: #EEEEEE;">VARCHAR2</span>
) data sent using <span style="font-size: 10.0pt; color: black; background: #EEEEEE;">WRITE_DATA</span>
is converted to US7ASCII before it is sent. If the text contains multibyte characters, each multibyte character in the text that cannot be converted to US7ASCII is replaced by a '?' character. If 8BITMIME extension is negotiated with the SMTP server using the