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

ID: 18449 Updated by: thies@php.net Reported By: dehaili@netease.com -Status: Open +Status: Closed Bug Type: OCI8 related Operating System: Redhat Linux 7.3 PHP Version: 4.2.1 New Comment: don't use SetEnv in httpd.conf -> please set the oracle env-vars in you apache start (shell-)script. Previous Comments: ------------------------------------------------------------------------ [2002-07-20 17:38:54] dehaili@netease.com sqlplus works nls_lang and database charset change to 'zhs16cgb231280' cannot work too ------------------------------------------------------------------------ [2002-07-20 17:32:47] dehaili@netease.com 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 this bug report at http://bugs.php.net/?id=18449&edit=1