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

don't trust internal environmental variables in PHP. Don' know why and this may only be oracle but I've had problems and talked to others with the same. Tim Parkin -----Original Message----- From: Guridi, Jose [mailto:jguridi@infoera.cl] Sent: 14 December 2000 13:42 To: php-db@lists.php.net Subject: [PHP-DB] 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? -- 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