NLS_PARAMETERS in 8?

Not sure about NT, but I had a similar problem two weeks ago on HP-UX. Check out NLS_NUMERIC_CHARACTERS in the server reference manual. This allows you to override the settings derived from NLS_TERRITORY (in case these are wrong). In INIT<SID>.ORA, put this :

NLS_NUMERIC_CHARACTERS = ',.' That was a comma and a dot. The first (comma) is the decimal character, the second (dot) is the group separator. This combination means that any numeric values now have to be in quotes if the decimal character is not a dot and/or the group separator is used in numbers. (See section 4-24 in server reference for details.)

Also (?) Check out the setting for NLS_LANG which I had to set to AMERICAN_AMERICA_WE8DEC to get the character set I wanted. (We import dumps from Germany and need the accented characters but a copy database was dropping the accents even though it has a WE8DEC character set.

HTH. Regards Norman Dunbar.

-----Original Message-----
From: Göran K [mailto:goranNOgoSPAM_at_champion.se.invalid] Subject: NLS_PARAMETERS in 8?

Hi

I have just migrated a database from 7.3.3 to 8.0.5 It's running on NT4 w SP4.

I am loading data with SQLLDR.
In the data there are Price-columns, that is values with decimals. The data comes with ',' as decimalseparator.

In 7.3.3 it worked fine, now in the 8.0.5 sqlldr80 protests about the price-column. I've tried to set: NLS_TERRITORY = SWEDEN (and also: NLS_ISO_CURRENCY = SWEDEN)
in the initDB.ora-file.

But it still doesn't work, and if i select * from v$nls_parameters I still have AMERICA and AMERICAN everywhere! What should I do?

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!