Unicode output

From: Louis Avrami <avramil_at_concentric.net>
Date: Fri, 17 May 2002 16:08:25 -0800
Message-ID: <F001.00463E43.20020517160825@fatcity.com>

Hello all,

We're running Oracle RDBMS 8.1.7.2 on a Solaris 2.8 server platform.

The development team for a particular project has written a stored procedure for sending data feeds to other projects. It spools outputs of queries to UTL_FILE_DIR, and then other processes E-mail the output files to vearious recipients.

This database has international users. The NLS_LANG setting is AMERICAN_AMERICA.UTF8. Up until now all of the output files have looked fine, but recently an end-user in Mexico has inputted an address that looks in part like this:

México

It should look like "Mexico" with an accent above it ...

The recipients of this particular spool file are complaining that this output is "wrong", which I guess it is, from their perspective.

Does anyone have any suggestions on a setting or process that could "correct" this, or somehow "filter" the output, or a workaround?

I wish that the recipients could connect to the database directly, query the data they need and pull it into their own database, but that isn't how things are structured with this client.

Any suggestions would be welcome.

Thanks,
Lou Avrami

--

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

Author: Louis Avrami
  INET: avramil_at_concentric.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 17 2002 - 19:08:25 CDT