[PHP3] Retrieving data from database (fwd)

Just in case you don't read the php3 list. Interesting to get a note from an Oracle tech support manager. ---------- Forwarded message ---------- Date: Thu, 16 Sep 1999 15:03:50 +0100 From: Yura Gauchman <YGAUCHMA@IL.oracle.com> To: php3@lists.php.net Cc: ruthy@techunix.technion.ac.il Subject: [PHP3] Retrieving data from database Hello all, I am Yuri Gauchman, Oracle Israel National Language Support manager. One of our customers uses PHP3 +Apache Web Server to put/retrieve data to/from Oracle 8.0.4 database. He uses Oracle OCI API. The problem is that PHP3 retrieves regular English characters as UNICODE ones - two bytes for each character, i.e. A is 0A, B as 0B, C as 0C ... Questions: 1) As far as I understand PHP3 works with Oracle OCI interface. As Oracle database he uses is a single character one (Character set Iw8ISO8859P8) What makes PHP3 to retrieve data in UNICODE like character set? 2) Usually OCI uses environment variable ORA_NLS32 (or ORA_NLS33) and NLS_LANG for proper character set conversion between Oracle OCI program on the client and Oracle Server. (ORA_NLS33 points to $ORACLE_HOME/ocommon/nls/admin/data) PHP3 retrieves the same UNICODE like data either independently either ORA_NLS33 exist or does not. The same with NLS_LANG environment variable. It looks very strange. Why the normal Oracle environment does not make any difference for PHP3? Should we reload WEB SERVER every time after changing of PHP3 script? P.S. The customer uses Oracle8 database with IW8ISO8859P8 charset, but not standard WE8ISO8859P1. Is it should be the problem? The best regards, Yuri. -- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe@lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin@lists.php.net