Probleme upper accents

From: Date: Fri, 05 Apr 2013 12:38:36 +0000
Subject: Probleme upper accents
Groups: php.db 
Request: Send a blank email to php-db+get-48717@lists.php.net to get a copy of this message
Hi, On my application PHP with Oracle database, all work fine with Oracle9i client, but when I test with Oracle11gR2 client I get warning with PDO driver. *Warning*: PDOStatement::fetch() [function.PDOStatement-fetch <http://vanves23/function.PDOStatement-fetch>]: column 0 data was too large for buffer and was truncated to fit it in with this request " SELECT DISTINCT UPPER(SUBSTR(NOM, 1, 1)) AS INITIALE, NOM
                               FROM MY_TABLE ORDER BY INITIALE ";
The field NOM contain in first character upper character with accent like this É Î Here are my configuration : - Apache2.2.21 - Php-5.1.4 with PDO Oracle - Client Oracle 11.2.0.1 - Base Oracle 11.2.0.1 On my Web server, I have set : ORACLE_BASE ORACLE_HOME TNS_ADMIN NLS_LANG = French_France.WE8ISO8859P1 LC_ALL=fr_FR 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" /> And on my Oracle Dababase server, I have NLS_CHARACTERSET=WE8ISO8859P15 NLS_NCHAR_CHARACTERSET= AL16UTF16 How I can suppress these warnings ? Thanks for your help.

« previous php.db (#48717) next »