Oracle 10g: Special characters are not correctly returned 30 minutes after each Apache restart

From: Date: Tue, 01 Nov 2005 22:57:06 +0000
Subject: Oracle 10g: Special characters are not correctly returned 30 minutes after each Apache restart
Groups: php.db 
Request: Send a blank email to php-db+get-40582@lists.php.net to get a copy of this message
Dear all, I'm noticing a very strange problem with my Apache/PHP/Oracle installation. Imediatelly after an Apache restart, it all works OK. But, ~30 minutes later, all the special characters (namely, portuguese accentuated characters) obtained from the DB disappear and are replaced by other chars like "?". It seems to be a PHP-Oracle interface problem, given that all the characters are always OK when the connection is made through TOAD. The variables ORACLE_HOME e NLS_LANG are defined with the following values: ORACLE_HOME=/export/ORACLE/OraHome1 NLS_LANG=American_America.WE8ISO8859P15 Does anyone have a clue on what it's happening? My system: Apache 2.0.52 + PHP 4.3.11 + Oracle 10g (through OCI8) Thanks in advance. Cheers, Paulo Sousa

« previous php.db (#40582) next »