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

ID: 18449 Updated by: dehaili@netease.com Reported By: dehaili@netease.com Status: Closed Bug Type: OCI8 related Operating System: Redhat Linux 7.3 PHP Version: 4.2.1 New Comment: can not work too, or, worse i did what you tell me, but it failed connect to oracle when nls_lang not set charset to 'american_america.us7asii'. this time ocilogon return ora-12705 'unsupported character set'! Previous Comments: ------------------------------------------------------------------------ [2002-07-21 04:17:16] thies@php.net don't use SetEnv in httpd.conf -> please set the oracle env-vars in you apache start (shell-)script. ------------------------------------------------------------------------ [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