strange behavior of varchar2 in oracle
| From: | Guridi, Jose | Date: | Tue, 12 Dec 2000 20:41:54 +0000 |
| Subject: | strange behavior of varchar2 in oracle | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5192@lists.php.net to get a copy of this message | ||
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