#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: +Assigned To: maxim New Comment: Can you try the latests CVS snapshot? There have been lots of fixes in mbstring. It might depend on it. Previous Comments: ------------------------------------------------------------------------ [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". ------------------------------------------------------------------------ [2002-05-23 05:34:35] robert.earls@lis.co.uk Email typo in original post.. :-) ------------------------------------------------------------------------ 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