ID: 35003 Comment by: vs at ez dot no Reported By: [EMAIL PROTECTED] Status: Assigned Bug Type: Oracle related Operating System: Linux - Fedora Core 1 PHP Version: 5.1.0RC3 Assigned To: tony2001 New Comment:
Note that the query result is wrong. There actually should have been 0 instead of "". This is probably caused by the same problem. Previous Comments: ------------------------------------------------------------------------ [2005-10-27 18:22:56] [EMAIL PROTECTED] Description: ------------ Strange warning when fetching data from an Oracle DB with PDO: "column N data was too large for buffer and was truncated to fit it" Reproduce code: --------------- Environment: ============ PHP version: 5.1.0RC3 Server version: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production Client libraries: oracle-instantclient 10.1.0.4 OS: Fedora Core 1 How to reproduce: ================= 1. Execute the following query on your Oracle database: CREATE TABLE pdotest (some_num INTEGER DEFAULT 0 NOT NULL); 2. Run the following script: =============================================================================== <? $query="SELECT data_default FROM user_tab_columns WHERE table_name='PDOTEST'"; $db = new PDO('oci:dbname=orcl', 'trunk', 'tiger'); $sth = $db->query( $query ); for( $i=0; ( $row = $sth->fetch( PDO::FETCH_ASSOC ) ); $i++ ) var_dump( $row ); echo "$i rows fetched.\n"; ?> =============================================================================== Expected result: ---------------- No warnings. Actual result: -------------- Warning: PDOStatement::fetch(): column 0 data was too large for buffer and was truncated to fit it in /path/to/test.php on line 7 array(1) { ["DATA_DEFAULT"]=> string(0) "" } 1 rows fetched. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35003&edit=1