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

ID: 17381 Comment by: cmueller at gmx dot de Reported By: robert dot earls at lsi dot co dot uk Status: Open Bug Type: OCI8 related Operating System: Win NT PHP Version: 4.2.1 Assigned To: maxim New Comment: Hi, setting NLS_LANG via putenv in PHP or via SetEnv in the httpd.conf doesn't seem to work. Try to set it in the environment that starts apache. This solved the problem for me. search http://www.php.net/manual/en/ref.oci8.php for NLS_LANG for more info Previous Comments: ------------------------------------------------------------------------ [2003-03-11 10:51:37] junk at deathpix dot com I am using PHP 4.3.2, Apache 1.3.27, Oracle 8.1.7 on IRIX. I cannot get UTF-8 characters into or out of the database. I also cannot use any of the mb_* functions, despite building PHP with mb enabled. I can get characters into the database, and they appear correct, but what actually gets entered is "& # 21054;& # 21074; $ # 21091;& # 21112". I can pull this data back out of the database with PHP and display it fine on a page. However, if I use another app to look at that same data, it displays "????". Concurrently, if I enter data through another app into the same database table, the data appears correctly in that app, but in PHP the data shows up as "?????". Through trial and error I have determined that the offending app/code is PHP. Have there been any updates since this thread was last posted to in regard to mb support??? Thanks for your time. ------------------------------------------------------------------------ [2003-01-27 14:57:42] maxim@php.net 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 ------------------------------------------------------------------------ [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 at adm dot 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 dot mccleary at operon dot 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? ------------------------------------------------------------------------ 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