Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> NLS_TERRITORY SWITZERLAND and numeric characters some considerations

NLS_TERRITORY SWITZERLAND and numeric characters some considerations

From: Peter Gurtner <peter.gurtner_at_iclip.ch>
Date: 13 Jun 2002 08:25:27 -0700
Message-ID: <240a0b91.0206130725.3b43335d@posting.google.com>


If i change the territory to SWITZERLAND

ALTER SESSION SET NLS_TERRITORY='SWITZERLAND'; the numeric characters change to the german settings ,. and not to the expected .'

I can change these setting with

ALTER SESSION SET NLS_NUMERIC_CHARACTERS='.'''; And i get the result ins SQL*Plus, but in i still have a problem in java with jdbc thin driver. In the thin driver changes the territory according to the locale settings of the OS and JAVA VM settings. It does an alter session with the wrong numeric characters ,.

I canged to the java oci driver and pachted the resource file lx10031.nlb.

Now I' ve got problems with jobs !
Most of the dbms_job commands like submit, what do copy the actual copy
of your national language enviromnent in job table. This does add the values .' for numeric characters as NLS_NUMERIC_CHARACTERS = ','' (wrong)
instead of NLS_NUMERIC_CHARACTERS = ',''' (correct). This job will never run !

Does any use a better strategy to avoid problems with swiss national settings in oracle .

Bye

Peter Received on Thu Jun 13 2002 - 10:25:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US