Bug #18449: OCI8 NLS_LANG set, but wrong result ('???')

From: dehaili@netease.com Operating system: Redhat Linux 7.3 PHP version: 4.2.1 PHP Bug Type: OCI8 related Bug description: OCI8 NLS_LANG set, but wrong result ('???') i installed redhat linux 7.3, and then oracle 8.1.7. i created a database whose character set is "AMERICAN_AMERICA.ZHS16GBK". within the database, i: create table xxx ( a varchar2 ( 256 ) ); as my php4.1.2 that shiped with RH7.3 had no --with-oci8 option set, oci funcstions didn't work. so i downloaded php4.2.1 and modified its makerpm file to add --with-oci8 and --with-oracle options and run sh makerpm and then installed the rpm. i also add SetEnv ORACLE_HOME ... ... SetEnv NLS_LANG "AMERICAN_AMERICA.ZHS16GBK" ... to the file: /etc/httpd/conf/httpd.conf, this time oci functions works. BUT, the PROBLEM is: when my sql statment is select a from xxx; the result contain many '???' instead of my chinese words I set NLS_LANG as root and the apachectl stop, apachectl start, this time, ocilogon failed with ora-12705 "charset no supported" can you help me? thx a lot -- Edit bug report at http://bugs.php.net/?id=18449&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18449&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18449&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18449&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18449&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18449&r=support Expected behavior: http://bugs.php.net/fix.php?id=18449&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18449&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18449&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18449&r=globals