RE: NLS_CHARACTERSET not being recognized?? help!

SET SERVEROUTPUT ON SIZE 1000000;
DECLARE
i NUMBER DEFAULT 150;
buffer VARCHAR2(100) DEFAULT NULL;
BEGIN
WHILE i <= 255 LOOP
buffer := buffer ||TO_CHAR(i)||'='||chr(i)||' '; IF LENGTH(buffer) > 79 THEN

   dbms_output.put_line(buffer);
   buffer := '';
END IF;
i := i + 1;
END LOOP;
IF LENGTH(buffer) > 0 THEN

   dbms_output.put_line(buffer);
END IF;
END;
/

The above was a small script posted earlier to check for ASCII characters above 150
Does your .profile have a diff NLS_LANG ? Try echoing your NLS_LANG..
I have learnt that if the database is created with e.g. WE8ISO8859P1, and the Unix user doing the export doesn’t have NLS_LANG set, I believe the default will be US7ASCII.

HTH Geeta Iyer
Sprint Enterprise Network Services
Work: (303)220-4788
Pager: 800-724-3508
E-Mail: Geeta.Iyer_at_SprintParanet.com

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Veronica Levin
Sent: Wednesday, June 14, 2000 2: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
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_DATE_FORMAT                'DD-MON-RR'
NLS_DATE_LANGUAGE              AMERICAN
NLS_CHARACTERSET               WE8ISO8859P1
NLS_SORT                       BINARY
NLS_CALENDAR                   GREGORIAN
NLS_RDBMS_VERSION              7.3.4.0.0

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

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

Thanks for any input on this topic,

Saludos,

Verónica Levin Enríquez
Administrador AIX
Compañía Cervecera de Nicaragua
Teléfono: 505-2493779
Fax: 505-2443979
Email: vlevin_at_victoria.com.ni
http://victoria.com.ni

--
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