ID: 17381 Comment by: junk at deathpix dot com 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:
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. Previous Comments: ------------------------------------------------------------------------ [2003-01-27 14:57:42] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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? ------------------------------------------------------------------------ [2002-07-23 05:09:59] dehaili at netease dot 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". ------------------------------------------------------------------------ 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