Re: Spanish character problem

From: Syltrem <syltrem_at_videotron.ca.spammenot>
Date: Tue, 5 Jun 2001 16:05:38 -0400
Message-ID: <TQaT6.24111$X86.1072008@weber.videotron.net>

Hi!

An answer for a faithful (I hope) VMS user!

$ sh log nls*

(LNM$PROCESS_TABLE)

  "NLS_DATE_FORMAT" = "DD-MON-YYYY"
  "NLS_DATE_LANGUAGE" = "AMERICAN"
  "NLS_LANG" = "AMERICAN_CANADA.WE8ISO8859P1"
  "NLS_NUMERIC_CHARACTERS" = ".,"
  "NLS_SORT" = "CANADIAN FRENCH"

$ sear ora_root:[db_infrcs]init.ora nls

nls_language = "AMERICAN"
nls_territory = "CANADA"
nls_numeric_characters = ".,"
nls_sort="Canadian French"

You have to supply correct values for spanish for these NLS parameters BTW, NLS_LANG logical MUST be defined in order for accented characters to be displayed correctly (as in select 'Montréal' from dual;).

--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site)
To reply to myself directly, remove .spammenot from my address

"Jeff Smith" <jds1201_at_yahoo.com> a écrit dans le 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 - 15:05:38 CDT