CODEWITHSUNDEEP
oracle10g
Amol
Amol

Reputation: 1

Using Utl_mail package to send email on Oracle 10g grid

Can somebody please advice using special character in message body is allowed or not? I am using a word "month's" in the nessage body but it is getting replaced by "month?s" in the email. Please HELP!!!!

Upvotes: 0

Views: 938

Answers (2)

user313218
user313218

Reputation: 726

Absolutely! You can email special characters, in the Subject and the Body.

BEGIN
  UTL_MAIL.send(sender     => '[email protected]',
                recipients => '[email protected]',
                subject    => 'Cards? ♠♥♦♣',
                message    => 'Shall we play cards? ♠♥♦♣');
END;
/

If the special characters are being replaced by "?" then either the database or the email recipient does not have a UTF8 charcaterset

Upvotes: 0

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60312

Don't use MS Word to edit your code :)

Most probably, your editor is replacing the ' with a special left- or right-pointing apostrophe.

Try copying the code into a "plain" text editor (Notepad would do fine) and re-type the ' in the code, then recompile it.

Upvotes: 1

Related Questions