Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

Re: [PHP-DB] strange behavior of varchar2 in oracle From: Rouvas Stathis (rouvas <email protected>)
Date: 12/13/00

Sorry to dissapoint you, but it's not PHP's fault:-)
This question had appeared before some 6 months (or more) ago.
I don't remember the solution, but I think it had something to do with
the NLS_LANG environment variable. Make sure that PHP (that is the
web-server) has available the same set of environment variables as you
do when you run sqlplus. Oh, and make sure that you connect to the same
Ora-server :-)
Better check the archives (www.phpbuilder.com, www.faqts.com e.t.c.).
-Stathis.

"Guridi, Jose" wrote:
>
> I'm working for first time with oracle and php. using php403pl1 and oracle
> 8.
>
> I have this problem.
> When I try to get data from a varchar2 field I receive a 0 byte between each
> character.
> for example if the field contains 'john' I get 'j o h n ' the characters
> in between are not spaces but rather 00 hex.
> If I get the data with oracles's SQLPLUS i works fine so It seems like a php
> problem.
>
> also when I try to get data from a char field I get just a 0 byte and
> nothing more.
> again if I go to SQLPLUS I can see the data with no problem.
>
> An other point is that I can save data from php with no problem and then get
> it with sqlplus but if I try to get it with php I run into the problem
> again.
>
> any idea??
> Jose Guridi
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>