Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to send email with 8-bit Cyrillic characters (charset="windows-1251")?

70705Feb 12 2004 — edited Feb 13 2004
I’m trying to send an email message prepared in a CLOB and containing Cyrillic
characters.
But  . . . . all Cyrillic characters in the email are replaced with ’?’.

How to send Cyrillic characters using WWV_FLOW_MAIL?

Table structure:

create table messages
    (id number,
    subject varchar2(200),
    text clob,
    html_text clob /* Cyrillic */
    );

The process sending email:

begin
for c0 in (select subject, text, html_text
    from messages
    where id = :P413_ID) loop
   for c1 in (select email
        from members
        where id in (select member_id
            from member_groups
            where group_id = :P412_GROUP_ID)) loop
     if c1.email is not null then
        WWV_FLOW_MAIL.SEND(
            P_TO => c1.email,
          P_FROM => 'myemail@fixed.com',
           P_BODY => c0.text,
          P_BODY_HTML => c0.html_text, /* Cyrillic */
          P_SUBJ => c0.subject);
    end if;
    end loop;
 end loop;
end;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2004
Added on Feb 12 2004
5 comments
606 views