Probleme accents

ANDRE LAGADEC <[email protected]> Sun, 3 Mar 2013 12:35:54 +0100

Newsgroups	gmane.comp.php.database
Message-ID	<OF0E199B6F.ED3F2A81-ONC1257B23.003FB650-C1257B23.003FB653@education.gouv.fr>

Hi,

On my application PHP with Oracle database, all work fine but sometimes the caracters like 'éèàù' become 'eau' or '?', and after make apachectl stop/start
it become normal.

Here are my configuration :
   - Apache2.2.21 
   - Php-5.2.13 with PDO Oracle
   - Client Oracle 11.2.0.1 
   - Base Oracle 9.2.0.7
On my Web server, I have set :
ORACLE_BASE
ORACLE_HOME
TNS_ADMIN
NLS_LANG = French_France.WE8ISO8859P1
LANG=C
LC_COLLATE=fr_FR.ISO8859-1
LC_CTYPE=fr_FR.ISO8859-1
LC_MESSAGES=fr
LC_MONETARY=fr_FR.ISO8859-1
LC_NUMERIC=fr_FR.ISO8859-1
LC_TIME=fr_FR.ISO8859-1

In HTML headers of page, there is
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr"> 
 <head> 
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
  <meta name="language" content="fr" /> 
 
And on my Oracle Dababase server, I have
NLS_CHARACTERSET=WE8ISO8859P1
NLS_NCHAR_CHARACTERSET= AL16UTF16

Can somebody explain me how I can lost my accents in 'éèàùç', and how I can repair this ?
 
Thanks for your help.
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php