oracle replaces ISO-8859-1 characters with question marks

From: Noah <noahspurrier_at_gmail.com>
Date: 22 Feb 2005 15:35:51 -0800
Message-ID: <1109115351.600227.133240@l41g2000cwc.googlegroups.com>

The problem I'm having is that Latin-1 accented characters are getting stored as question marks in the database. For example, "façade" (c with cedilla) is stored as "fa?ade" Does anyone have any idea how to fix this problem?

I'm using Oracle 10g running on Linux.
This is the test query I ran from sqlplus:

    SQL> UPDATE release SET message='façade' WHERE release_id=5831;     1 row updated.
    SQL> select message from release where release_id=5831;     MESSAGE

---

    fa?ade

I have included my Oracle NLS database parameters. Is there some global server option I can set to allow ISO-8859-1 characters? Or is there some option I can set per query?

Yours,
Noah

SQL> select * from NLS_DATABASE_PARAMETERS;

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               WE8ISO8859P1
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              10.1.0.2.0

Received on Tue Feb 22 2005 - 17:35:51 CST