php, OCI and datatypes
| From: | dsi safir | Date: | Thu, 14 Feb 2002 09:23:10 +0000 |
| Subject: | php, OCI and datatypes | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6595@lists.php.net to get a copy of this message | ||
Hi,
I'm working with Oracle 8.05 and php4.04xx.
I'm selecting some datas in order to show them in a browser
(Netscape 4.03Fr or IE5.0).
I found out that my code works well with all datatypes but
CHAR.
Varchar2, date or numbers are retrieved and rendered in an
array without any problems.
With a char column, I can't see any values with Netscape and
with IE, I have less than half
of the string or nothing.
Example : select char_column, other_column from my_table; //
the query, char_column as a char(5) not null
The output with OCIFetchStatement or OCIFetchInto or else is
made with something like <TD>$data[$i]</TD>.
The char column is filled with a blank space on the first
row.
On the second row, the char column is filled with a blank
space between half of the initial string.
and so on...
Example : for "Hello" in the table, I get " H e l".(with IE,
with Netscape I get nothing at all).
So, any ideas ?
Emmanuel Nectoux