PL/SQL (MOSC)

MOSC Banner

Sending email that contains Hebrew characters with UTL_SMTP returns question marks

edited Sep 3, 2019 9:11AM in PL/SQL (MOSC) 2 commentsAnswered

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

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