AW: [PHP-DB] php, OCI and datatypes

use the display sourcecode function of your browser, it is more reliable than the output. try to get the char column with ocifetch($stmt); $charcol = ociresult($stmt, "nameofcharcol"); maybe your using [] the wrong way so you are getting the chars of the string instead of the strings in the row mk -----Ursprungliche Nachricht----- Von: dsi safir [mailto:dsi.safir@anpe.fr] Gesendet: Donnerstag, 14. Februar 2002 10:23 An: php-db@lists.php.net Betreff: [PHP-DB] php, OCI and datatypes 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 -- 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