Web page does not display special characters.
I have the following environment:
Ubuntu 10.04 LTS - the Lucid Lynx
PHP Version 5.3.2
Apache/2.2.14
Database: XE 10.2.0.1
OCI8
I have confirmed that the data in the database is correct by selecting from both SQL Plus and Oracle SQL Developer.
Scenario 1:
/etc/php5/cli/php.ini => default_charset = "UTF-8"
/etc/php5/apache2/php.ini => default_charset = "UTF-8"
/etc/apache2/apache2.conf => AddDefaultCharset UTF-8
/etc/environment => NLS_LANG=".AL32UTF8" echo $NLS_LANG is correct for all users.
The web page displays the data OK but with out the special characters.
Göldner is displayed as Goldner.
If I do an insert from the web page Göldner becomes G¿¿ldner.
Scenario 2:
Same as 1 with the following added.
/etc/apache2/envvars => NLS_LANG=".AL32UTF8"
The web page displays the data as Göldner and G¿¿ldner.
If I do an insert from the web page the data is inserted correctly.
I am at my wits end, I have used the following resources in an attempt to resolve this:
2 Day Plus PHP Developer Guide
TheUnderground_PHP_and_ORACLE_manual.pdf
globalizing-oracle-php-applications-131996.pdf
google.
Does anyone have any idea where my problem could be?
Regards;
Robert