Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> NLS_TERRITORY SWITZERLAND and numeric characters some considerations
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