Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

[PHP-DB] trange behavior of varchar2 in oracle From: Florian Clever (clever <email protected>)
Date: 12/14/00

What about your Session settings? Try ALTER SESSION CHARACTER_SET (I do
not remember the exact command).

Florian

-----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 

-- 

Florian Clever

fc <email protected>
http://www.Clever-Software-Solutions.de/

PGP Key @ ldap://certserver.pgp.net/

A day for firm decisions!!!!! Or is it?

-- 
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>