Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

RE: [PHP-DB] strange behavior of varchar2 in oracle From: Anthony Martin (Anthony <email protected>)
Date: 12/13/00

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 <email protected>]
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 <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>