The problem I'm having is that whenever a user enters
accented characters character into a form field the 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?
My page has a meta header to set Content-Type:
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
I traced the input to the PHP form submission page.
I printed the posted form fields and the characters
come through as expected, so I'm pretty sure that this
is a problem with the database side.
I'm using Oracle 10g running on Linux. I'm using PEAR db.
My update query is simple and straightforward:
UPDATE release SET message='façade' WHERE release_id=5831;
I have included my Oracle NLS database parameters.
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