Oracle and accented characters


I just amended the Wiki (OracleSetup) with the following (last part):
I did try with the defaults but that resulted in ?? instead of a
accented character. Modifying directly in the database using sqlplus
went OK but in the webinterface those accented characters went back to
??. So the problem was with Apache<->database
Setting various NLS_LANG parameters and restarting Apache resulted in
accented characters when the third parameter matched with the database
characterset. Other combinations should work too as long as the database
is a superset of the clientside.
Setting the clientside (apache) to the same as the database is the
easiest way, certainly when both apache and the database are on the same



Encoding problem with mod_perl2

(for RedHat El5, it can be
added to /etc/sysconfig/httpd which is sourced by /etc/init.d/httpd)

(remark: that didn’t work for me, it does when set to
AMERICAN_AMERICA.WE8MSWIN1252 which is also my database charset!, see