Re: UTL_SMTP: no special characters?

I thought I saw somewhere that it's possible to set the characterset for the email. This is certainly possible for a varchar2 field. So by setting the charset for your fields and email, and using the CHR() function you can insert special characters without a problem. But the you do need to know which code's represent which symbol though.. For example when using the US7ASCII character set, the CHR(10) is the carriage-return. You can probably look up the charactersets in some manual. I even believe I saw a manual describing how to support multiple languages on your database (8i), it was on technet.

HTH, Bastiaan Schaap
Oracle web development,
Desyde BV - Baarn
http://www.desyde.nl/
tel. +31355411711

negg <negg_at_my-deja.com> wrote in message news:8m8qsk$f8v$1_at_nnrp1.deja.com...
> Hi.
>
> I am trying to send german language emails (containing Umlauts) with
> UTL_SMTP. Everything would be fine, if the package would act like a
> normal telnet-session to the smtp-host. That means, when I am doing
> smtp-communication by hand, and I am sending Umlauts, they are sent as
> special characters, which are retranslated by normal german
> mailclients. UTL_SMTP seems to have difficulties in handling those
> Umlauts, and automatically translates an "ä" (=ae) to "a"...
>
> Anybody knows why? Anybody knows how to send Umlaut-emails with
> utl_smtp? (I thought this was the year 2000, not 1975.. ;-)
>
> Thanks,
> negg.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Aug 03 2000 - 00:00:00 CDT