>From sqlplus: select * from v$nls_parameters' Here you will find the actual character set.
Ask you DBA if the character set was changed during the upgrade. There are special procedures for this, and you can get unexpected results if not followed properly. Jared On Saturday 25 January 2003 17:52, Jeff Gross wrote: > I have a problem connecting to Oracle 8.1.7 with dbi > > I have been using the Perl DBI to connect to Oracle with success until an > upgrade to Oracle 8.1.7. Now dbi will not connect unless I have the > following environment variable setting > > setenv NLS_LANG AMERICAN_AMERICA.US7ASCII > > The problem is that I am retrieving Eastern European character from Oracle > and some of them are translated into question marks "?". The Oracle > database administrator suggested that I use the following env setting > > setenv NLS_LANG AMERICAN_AMERICA.EE8ISO8859P2. The problem with this > setting is that the DBI connect fails. The error message is > > DBI->connect failed: ORA-12705: invalid or unknown NLS parameter value > specified (DBD: login failed) at oracle_connect.pl line 10 > Unable to connect: ORA-12705: invalid or unknown NLS parameter value > specified (DBD: login failed) at oracle_connect.pl line 10. > > > Thank you for your time and any help is most appreciated. > > Jeff Gross > > _________________________________________________________________ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus
