Varchars in oracle and php

From: Date: Wed, 04 Jul 2001 02:20:16 +0000
Subject: Varchars in oracle and php
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-10055@lists.php.net to get a copy of this message
Hi there, I have a question regarding oracle and php oracle is running in a win2000 machine, php in a linux machine, i have finally connected them and they work fine. the problem is that when i do a "select xxxx from ......." and xxxx is a varchar php doesn't display them correctly, as a matter of fact, it doens't display them at all. i tried using function like ltrim, but when i use them i only get the first character if xxxx is an int it has no problem for example: $query="select xxxx from mytable"; $result=Ora_Parse ($cursor, $query); $result = Ora_Exec ($cursor); Ora_Fetch_Into ($cursor, &$values); echo "i have ".$values[0]." stored "; now, here's the funny part, when i view the page using lynx i have no problem, it displays everything correctly, but i use netscape it just display i have !!! i dont get it, even if $values[0] has no value, it should have displayed i have stored can anyone help me here?

« previous php.db (#10055) next »