Probleme accents
| From: | ANDRE LAGADEC | Date: | Sun, 03 Mar 2013 11:35:54 +0000 |
| Subject: | Probleme accents | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48701@lists.php.net to get a copy of this message | ||
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.