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!!!!
+1
A:
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.
Jeffrey Kemp
2010-02-10 04:20:21
A:
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