HOW TO: Mail containing multilingual text from database

From: Suneet <suneet.madhok_at_patni.com>
Date: Fri, 12 Mar 2004 13:48:01 +0530
Message-ID: <00d401c4080a$9835e2e0$fb00a8c0@patni.com>

Hi List,

How do we send data in multilingual format via mails in Oracle?

A scheduled backend job has to generate mail with data fetched from db tables containing multilingual text.
A procedure is called that pulls data from tables, does some calculations and then generates a message body text. This text contains multilingual characters. Have tried using utl_tcp, utl_smtp but couldnt get it done.

I got OUTLOOK as mail client. Now when i recieve mails sent via db procedure implementing utl_tcp, i see junk characters. What could be the problem here? How do i identify whether its a problem in sending mail through backend or there is some setting in OUTLOOK that i've to do.

Database Settings:
Ver = 9.2.0.1.0
NLS_CHARACTERSET = AL32UTF8
NLS_NCHAR_CHARACTERSET = AL16UTF16 Outlook settings:
OUTLOOK -> Tools -> Options -> Mail Format -> International Options -> Use this encoding for unmarked received messages: Unicode (UTF-8)

Any pointers..??

Thnx
Suneet

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Mar 12 2004 - 02:10:24 CST