php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #18449 OCI8 NLS_LANG set, but wrong result ('???')
Submitted: 2002-07-20 17:32 UTC Modified: 2002-11-10 09:48 UTC
From: dehaili at netease dot com Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 4.2.1 OS: Redhat Linux 7.3
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: dehaili at netease dot com
New email:
PHP Version: OS:

 

 [2002-07-20 17:32 UTC] dehaili at netease dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-07-20 17:38 UTC] dehaili at netease dot com 
sqlplus works

nls_lang and database charset change to 'zhs16cgb231280'
cannot work too
 [2002-07-21 04:17 UTC] thies@php.net 
don't use SetEnv in httpd.conf -> please set the oracle 
env-vars in you apache start (shell-)script.
 [2002-07-23 05:23 UTC] dehaili at netease dot 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:25 UTC] dehaili at netease dot 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-08-06 23:58 UTC] dehaili at netease dot com 
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.
 [2002-11-10 00:27 UTC] maxim@php.net 
It's been here for a while and looks to me that the whole thing was kinda resolved. Classifying as Suspended.

Maxim Maletsky
 [2002-11-10 09:48 UTC] sniper@php.net 
not a bug
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Feb 05 10:01:30 2025 UTC