#18449 [Com]: OCI8 NLS_LANG set, but wrong result ('???')

ID: 18449 Comment by: dehaili@netease.com Reported By: dehaili@netease.com Status: Open Bug Type: OCI8 related Operating System: Redhat Linux 7.3 PHP Version: 4.2.1 New Comment: ok now sorry i used wrong --php-config-file-path so the php.ini is missing. after corrected the php.ini problem, the nls_lang problem was overcome. just as you said, only NLS_LANG set in apachectl script works. it is not perfect solution for i can not use multi-language php-oracle couples in one apache+php server. thanks for your help. Previous Comments: ------------------------------------------------------------------------ [2002-07-23 05:25:21] dehaili@netease.com 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'! ------------------------------------------------------------------------ [2002-07-23 05:23:43] dehaili@netease.com 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'! ------------------------------------------------------------------------ [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