RE: [PHP-DB] strange behavior of varchar2 in oracle

This isn't a fix or anything, but does it do the same thing if you use TO_CHAR() on the VARCHAR2 field? I don't even know if that's a legal SQL construct in Oracle, but you get the idea. For that matter, what about "SELECT 'ABC' DUMMY FROM DUAL ;" ? Anthony -----Original Message----- From: Guridi, Jose [mailto:jguridi@infoera.cl] Sent: Tuesday, December 12, 2000 12:42 PM To: Php Db Mailing (Correo electrónico) Subject: [PHP-DB] strange behavior of varchar2 in oracle 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