[PHP-DB] Probleme accents
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
[PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g
Hello, I am on Solaris 10 X86 with DELL IP , and I compile Php-5.2.9 with Apache2, Mysql6 and Oracle10g with success. But when I want to connect to Oracle database I get a core dump. I use this code ?php $c=ocilogon('bceconsulter','bce','BCE'); print_r($c); Resource id #1 ocilogoff($c); ? and I run it with the command /usr/local/apache2_php5_2_9/bin/php -a I recompile PHP with --enable-debug and I run gdb to get a backtrace. I get this serveur7#/usr/local/apache2_php5_2_9/bin/php -a Interactive mode enabled ?php $c=ocilogon('scott','tigger','DB1'); Erreur de segmentation (core dumped) serveur7#gdb /usr/local/apache2_php5_2_9/bin/php ./core GNU gdb 6.8 Copyright (C) 2008 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type show copying and show warranty for details. This GDB was configured as i386-pc-solaris2.10... Reading symbols from /usr/lib/libcrypt_d.so.1...done. Loaded symbols for /usr/lib/libcrypt_d.so.1 Reading symbols from /usr/local/imap-2007e/lib/libc-client.so...done. Loaded symbols for /usr/local/imap-2007e/lib/libc-client.so Reading symbols from /usr/lib/libz.so.1...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /usr/lib/libexslt.so.0...done. Loaded symbols for /usr/lib/libexslt.so.0 Reading symbols from /usr/local/lib/libtidy-0.99.so.0...done. Loaded symbols for /usr/local/lib/libtidy-0.99.so.0 Reading symbols from /usr/lib/librt.so.1...done. Loaded symbols for /usr/lib/librt.so.1 Reading symbols from /usr/local/mysql-connector-c-6.0.2-solaris10-x86-32bit/lib/libmysql.so.16...done. Loaded symbols for /usr/local/mysql-connector-c-6.0.2-solaris10-x86-32bit/lib/libmysql.so.16 Reading symbols from /usr/local/lib/libmcrypt.so.4...done. Loaded symbols for /usr/local/lib/libmcrypt.so.4 Reading symbols from /usr/local/lib/libltdl.so.7...done. Loaded symbols for /usr/local/lib/libltdl.so.7 Reading symbols from /usr/lib/libldap.so.5...done. Loaded symbols for /usr/lib/libldap.so.5 Reading symbols from /usr/lib/libpam.so.1...done. Loaded symbols for /usr/lib/libpam.so.1 Reading symbols from /usr/local/lib/libintl.so.8...done. Loaded symbols for /usr/local/lib/libintl.so.8 Reading symbols from /usr/local/lib/libiconv.so.2...done. Loaded symbols for /usr/local/lib/libiconv.so.2 Reading symbols from /usr/lib/libsec.so.1...done. Loaded symbols for /usr/lib/libsec.so.1 Reading symbols from /usr/lib/libc.so.1...done. Loaded symbols for /usr/lib/libc.so.1 Reading symbols from /usr/sfw/lib/libfreetype.so.6...done. Loaded symbols for /usr/sfw/lib/libfreetype.so.6 Reading symbols from /usr/lib/libpng12.so.0...done. Loaded symbols for /usr/lib/libpng12.so.0 Reading symbols from /usr/lib/libjpeg.so.62...done. Loaded symbols for /usr/lib/libjpeg.so.62 Reading symbols from /usr/local/ssl/lib/libssl.so.0.9.8...done. Loaded symbols for /usr/local/ssl/lib/libssl.so.0.9.8 Reading symbols from /usr/local/ssl/lib/libcrypto.so.0.9.8...done. Loaded symbols for /usr/local/ssl/lib/libcrypto.so.0.9.8 Reading symbols from /usr/lib/libresolv.so.2...done. Loaded symbols for /usr/lib/libresolv.so.2 Reading symbols from /usr/lib/libm.so.2...done. Loaded symbols for /usr/lib/libm.so.2 Reading symbols from /usr/lib/libnsl.so.1...done. Loaded symbols for /usr/lib/libnsl.so.1 Reading symbols from /usr/lib/libsocket.so.1...done. Loaded symbols for /usr/lib/libsocket.so.1 Reading symbols from /usr/lib/libxml2.so.2...done. Loaded symbols for /usr/lib/libxml2.so.2 Reading symbols from /usr/lib/libkstat.so.1...done. Loaded symbols for /usr/lib/libkstat.so.1 Reading symbols from /usr/lib/libgen.so.1...done. Loaded symbols for /usr/lib/libgen.so.1 Reading symbols from /usr/lib/libdl.so.1...done. Loaded symbols for /usr/lib/libdl.so.1 Reading symbols from /usr/lib/libsched.so.1... warning: Lowest section in /usr/lib/libsched.so.1 is .dynamic at 0074 done. Loaded symbols for /usr/lib/libsched.so.1 Reading symbols from /produits/oracle/product/10.2.0/lib32/libclntsh.so.10.1...done. Loaded symbols for /produits/oracle/product/10.2.0/lib32/libclntsh.so.10.1 Reading symbols from /usr/lib/libthread.so.1... warning: Lowest section in /usr/lib/libthread.so.1 is .dynamic at 0074 done. Loaded symbols for /usr/lib/libthread.so.1 Reading symbols from /usr/lib/libxslt.so.1...done. Loaded symbols for /usr/lib/libxslt.so.1 Reading symbols from /usr/sfw/lib/libgcc_s.so.1...done. Loaded symbols for /usr/sfw/lib/libgcc_s.so.1 Reading symbols from /usr/lib/libpthread.so.1... warning: Lowest section in /usr/lib/libpthread.so.1 is .dynamic at 0074 done. Loaded symbols for /usr/lib/libpthread.so.1 Reading symbols from /usr/lib/libaio.so.1...done. Loaded symbols for /usr/lib/libaio.so.1 Reading symbols from /usr/lib/libmd.so.1...done. Loaded symbols for /usr/lib/libmd.so.1 Reading symbols from /usr/lib/libcmd.so.1...done. Loaded symbols for
Re: [PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g
Hi, My LD_LIBRARY_PATH was /produits/oracle/product/10.2.0/lib32:/produits/oracle/product/10.2.0/network/lib32:/usr/local/lib:/usr/lib:/usr/sfw/lib If I execute the command ldd -d /produits/oracle/product/10.2.0/lib32/libclntsh.so.10.1 I get this result libnnz10.so = /produits/oracle/product/10.2.0/lib32/libnnz10.so libkstat.so.1 = /usr/lib/libkstat.so.1 libnsl.so.1 = /usr/lib/libnsl.so.1 libsocket.so.1 =/usr/lib/libsocket.so.1 libgen.so.1 = /usr/lib/libgen.so.1 libdl.so.1 =/usr/lib/libdl.so.1 libsched.so.1 = /usr/lib/libsched.so.1 libaio.so.1 = /usr/lib/libaio.so.1 librt.so.1 =/usr/lib/librt.so.1 libm.so.2 = /usr/lib/libm.so.2 libc.so.1 = /usr/lib/libc.so.1 libmp.so.2 =/usr/lib/libmp.so.2 libmd.so.1 =/usr/lib/libmd.so.1 libscf.so.1 = /usr/lib/libscf.so.1 libdoor.so.1 = /usr/lib/libdoor.so.1 libuutil.so.1 = /usr/lib/libuutil.so.1 But, if I execute ldd -d ldd -d /produits/oracle/product/10.2.0/lib32/libnnz10.so I get these errors messages. symbole introuvable : __ctype_mask (/produits/oracle/product/10.2.0/lib32/libnnz10.so) symbole introuvable : h_errno (/produits/oracle/product/10.2.0/lib32/libnnz10.so) symbole introuvable : __iob (/produits/oracle/product/10.2.0/lib32/libnnz10.so) symbole introuvable : nltrc_entry (/produits/oracle/product/10.2.0/lib32/libnnz10.so) symbole introuvable : nltrc_exit (/produits/oracle/product/10.2.0/lib32/libnnz10.so) symbole introuvable : nzdacvalue (/produits/oracle/product/10.2.0/lib32/libnnz10.so) So there is something wrong in library. Any idea ? I continue to search on Google... -Christopher Jones christopher.jo...@oracle.com a écrit : - A : Andre LAGADEC andre.laga...@education.gouv.fr De : Christopher Jones christopher.jo...@oracle.com Date : 02/03/2010 17:58 cc: php-db@lists.php.net Objet : Re: [PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g At a guess, there is a clash with the SSL libraries or it is a libpthread problem - google around for background. Chris Andre LAGADEC wrote: Hello, I am on Solaris 10 X86 with DELL IP , and I compile Php-5.2.9 with Apache2, Mysql6 and Oracle10g with success. But when I want to connect to Oracle database I get a core dump. I use this code ?php $c=ocilogon('bceconsulter','bce','BCE'); print_r($c); Resource id #1 ocilogoff($c); ? and I run it with the command /usr/local/apache2_php5_2_9/bin/php -a I recompile PHP with --enable-debug and I run gdb to get a backtrace. I get this serveur7#/usr/local/apache2_php5_2_9/bin/php -a Interactive mode enabled ?php $c=ocilogon('scott','tigger','DB1'); Erreur de segmentation (core dumped) serveur7#gdb /usr/local/apache2_php5_2_9/bin/php ./core GNU gdb 6.8 Copyright (C) 2008 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type show copying and show warranty for details. This GDB was configured as i386-pc-solaris2.10... Reading symbols from /usr/lib/libcrypt_d.so.1...done. Loaded symbols for /usr/lib/libcrypt_d.so.1 Reading symbols from /usr/local/imap-2007e/lib/libc-client.so...done. Loaded symbols for /usr/local/imap-2007e/lib/libc-client.so Reading symbols from /usr/lib/libz.so.1...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /usr/lib/libexslt.so.0...done. Loaded symbols for /usr/lib/libexslt.so.0 Reading symbols from /usr/local/lib/libtidy-0.99.so.0...done. Loaded symbols for /usr/local/lib/libtidy-0.99.so.0 Reading symbols from /usr/lib/librt.so.1...done. Loaded symbols for /usr/lib/librt.so.1 Reading symbols from /usr/local/mysql-connector-c-6.0.2-solaris10-x86-32bit/lib/libmysql.so.16...done. Loaded symbols for /usr/local/mysql-connector-c-6.0.2-solaris10-x86-32bit/lib/libmysql.so.16 Reading symbols from /usr/local/lib/libmcrypt.so.4...done. Loaded symbols for /usr/local/lib/libmcrypt.so.4 Reading symbols from /usr/local/lib/libltdl.so.7...done. Loaded symbols for /usr/local/lib/libltdl.so.7 Reading symbols from /usr/lib/libldap.so.5...done. Loaded symbols for /usr/lib/libldap.so.5 Reading symbols from /usr/lib/libpam.so.1...done. Loaded symbols for /usr/lib/libpam.so.1 Reading symbols from /usr/local/lib/libintl.so.8...done. Loaded symbols for /usr/local/lib/libintl.so.8 Reading symbols from /usr/local/lib/libiconv.so.2...done. Loaded symbols for /usr/local/lib/libiconv.so.2 Reading symbols from /usr/lib/libsec.so.1...done. Loaded symbols for /usr/lib/libsec.so.1 Reading symbols from /usr/lib/libc.so.1...done. Loaded symbols for /usr/lib/libc.so.1 Reading symbols from /usr/sfw/lib