RE: trange behavior of varchar2 in oracle

Finally I solved it. Inster of using putenv(ORACLE_HOME=/......) in the php script. I set ORACLE_HOME in the script that runs apache before apache starts and the problem was solved. Very strange indeed but it worked. Thanks to all who tried to help. :0) -----Mensaje original----- De: Florian Clever [mailto:clever@ukl.uni-freiburg.de] Enviado el: jueves 14 de diciembre de 2000 3:30 Para: jguridi@infoera.cl; php-db@lists.php.net Asunto: trange behavior of varchar2 in oracle 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@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 -- Florian Clever fc@clever-soft.com http://www.Clever-Software-Solutions.de/ PGP Key @ ldap://certserver.pgp.net/ A day for firm decisions!!!!! Or is it?