#17381 [Opn]: OCI fetch routines not working with UTF8 DB

ID: 17381 Updated by: maxim@php.net Reported By: robert.earls@lsi.co.uk Status: Open Bug Type: OCI8 related Operating System: Win NT PHP Version: 4.2.1 Assigned To: maxim New Comment: Any updates on this? Has anyone tried this behaviour on PHP 4.3.0 or the latest CVS? There were some fixes in mbstring as well as CVS now has an improved NLS_LANG behavior for Oracle 9. I wonder if this problem still persists for you. Maxim Maletsky Previous Comments: ------------------------------------------------------------------------ [2002-11-22 07:58:44] maxim@php.net Can you try the latests CVS snapshot? There have been lots of fixes in mbstring. It might depend on it. ------------------------------------------------------------------------ [2002-11-18 11:21:02] erki@adm.ee I'm having exactly the same problem here. PHP 4.2.2 RH Linux 2.4.9-34smp #1 SMP i686 Apache/1.3.22 Oracle 8i database with UTF8 characterset. Heelp? ------------------------------------------------------------------------ [2002-09-27 10:55:29] s.mccleary@operon.com I am experiencing the same problem. PHP 4.2.2 Red Hat Linux 7.2 Apache 1.3.26 Unable to insert multi-byte strings into Oracle and select it back out. Using mbstring and oci8 functions. Any progress on this one? ------------------------------------------------------------------------ [2002-07-23 05:09:59] dehaili@netease.com I met this kind of problems too. my database's character set is zhs16cgb231280, zhs16gbk, can not work too. the output i got is "aa????bb????" which should be "aaXXXXbbXXXX" (X present a 2-byte-chinese char) i set the NLS_LANG use SetEnv in httpd.conf of apache, the NLS_LANG changed but he result is unchanged. someone suggested that use "export NLS_LANG=xxxx" in apachectl script file, i tried, but failed. all "xxxx" except use charset us7ascii failed with an oracle error ora-12705, "unacceptable char set". ------------------------------------------------------------------------ [2002-05-23 06:50:05] robert.earls@lis.co.uk Can I just point out that I have used putenv, to set NLS_LANG in the example, because I thought that the system-wide environment variable $NLS_LANG was not being picked up. It is currently set to "American_America.UTF8". ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/17381 -- Edit this bug report at http://bugs.php.net/?id=17381&edit=1