while using data-type nvarchar2 and sending an email, special characters like (€ ,£) get replaced by bizarre characters for example
| € test @#$ £
gets replaced by
| � test @#$ �
However using varchar, varchar2 and char datatype singularly gives the right result but not in multiple usage.
Multiple usage means as below
MailBody := '| € test @#$ £ ';
MailBody1 :='nvarCHAR2 = ' || MailBody;
MailBody2 := 'nCHAR = ' || MailBody;
recipients => 'email@example.com',
subject => 'test',
message => MailBody|| MailBody1 || MailBody2,
mime_type => 'text/html; charset=utf-8'
we are using NLS_CHARACTERSET as AL32UTF8
Kindly suggest the right datatype to be used and the cause of this issue.
from a few minutes earlier.
Do not ever multi-post Select the location for an inquiry and wait for a response.
If you want it moved to a different forum space, then "Report Abuse" on yourself and moderators will get notified.
This newer post is now locked.