I think by default it should work with AMERICAN. That is my default. In order to use extended character set, I set mine to FRENCH_FRANCE. I would suggest that this is a feature of your database.
Tim Vorce Ford Motor Company [EMAIL PROTECTED] -----Original Message----- From: Bacovcin, Michael/COR [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 5:59 PM To: '[EMAIL PROTECTED]' Subject: NLS_Lang ? Folks I'm trying to make a connection to an oracle database 8.1.7 that has a american_america.we8iso8859p1 character set. If I set the $ENV{NLS_LANG}=american_america.we8iso8859p1 I can't connect to the database. I get the ora-12705 invalid NLS_LANG error. Is there some way around this. All the FAQ's on the net just say set the NLS_LANG variable. Well that doesn't work. It works if I use american_america.US7ASCII. Mike Bacovcin Unix and Database administrator Ch2mhill [EMAIL PROTECTED] 303.713.2038
