Re: strange behavior of varchar2 in oracle

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@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net