Sending Multilingual Mails via PL/SQL in Oracle

From: Newbie <learning_still_at_hotmail.com>
Date: 10 Mar 2004 02:05:40 -0800
Message-ID: <6093c29e.0403100205.5ac4b3@posting.google.com>

Hi,

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. Have tried using utl_tcp, utl_smtp. I got OUTLOOK as mail client. Now when i recieve mails sent via db procedure implementing utl_tcp, i get to 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. Received on Wed Mar 10 2004 - 04:05:40 CST