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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: NLS_CHARACTERSET not being recognized?? help!

RE: NLS_CHARACTERSET not being recognized?? help!

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 14 Jun 2000 16:38:22 -0400
Message-Id: <10528.109308@fatcity.com>


Make sure there is no environmental variable on the client side called nls_lang that is set to a different character set. Or make sure it is set to AMERICAN_AMERICA.WE8ISO8859P1

-----Original Message-----
From: Veronica Levin=20
Sent: Wednesday, June 14, 2000 4:48 PM
To: Multiple recipients of list ORACLE-L Subject: NLS_CHARACTERSET not being recognized?? help!

Hi listers,
Oracle 7.3.4, AIX 4.2.1

select * from NLS_DATABASE_PARAMETERS;

NLS_LANGUAGE                   AMERICAN                     =20
NLS_TERRITORY                  AMERICA                      =20
NLS_CURRENCY                   $                            =20
NLS_ISO_CURRENCY               AMERICA                      =20
NLS_NUMERIC_CHARACTERS         .,                           =20
NLS_DATE_FORMAT                'DD-MON-RR'                  =20
NLS_DATE_LANGUAGE              AMERICAN                     =20
NLS_CHARACTERSET               WE8ISO8859P1                 =20
NLS_SORT                       BINARY                       =20
NLS_CALENDAR                   GREGORIAN                    =20
NLS_RDBMS_VERSION              7.3.4.0.0=20

Database is updated via an application not builted in Oracle, and = suddenly
(not every day) data is not recognizing the nls_characterset:=20
the character "=F1" is being replaced by "?".

Any ideas of what should I check to solve this???

Thanks for any input on this topic,

Saludos,

Ver=F3nica Levin Enr=EDquez
Administrador AIX
Compa=F1=EDa Cervecera de Nicaragua
Tel=E9fono: 505-2493779
Fax: 505-2443979
Email: vlevin_at_victoria.com.ni=20
http://victoria.com.ni

--=20
Author: Veronica Levin
  INET: vlevin_at_victoria.com.ni

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). Received on Wed Jun 14 2000 - 15:38:22 CDT

Original text of this message

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