Re: Spanish character problem

From: Chris Wiss <chris_at_purecarbonnospam.com>
Date: Tue, 5 Jun 2001 15:22:38 -0400
Message-ID: <9fjb7f$1pv3$1@msunews.cl.msu.edu>

The Spanish data is an extended character. When viewing the file, you must have a utility capable of properly interpreting the extended data.

If are familiar with Perl, you could write a Perl script to extract the data and write an HTML file that would support the Spanish characters.

Good luck,
Chris Weiss

"Jeff Smith" <jds1201_at_yahoo.com> wrote in message news:672cc2ae.0106050941.6d1ccf6f_at_posting.google.com...
> We're running Oracle 8i on VMS and having trouble with the display of
> spanish characters.
>
> I've set the NLS_LANG parameter in the environment (define/system
> NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1). This allows the proper
> display through SQL*Plus, but when I execute PL/SQL stored procedures
> which pull this data and sends it to a file (using utl_file.put_line),
> the file does not display the characters correctly.
>
> Do I need to change a parameter in my init.ora file (which one?) or is
> there something I can do within the stored procedure to change the
> characterset?
>
> Any help is appreciated.
>
> Thanks.
>
> Jeff
Received on Tue Jun 05 2001 - 14:22:38 CDT