#38976 [Com]: missing last character when fetching query

ID: 38976 Comment by: jason at southerntextile dot com Reported By: zolfi at parspooyesh dot com Status: No Feedback Bug Type: PDO related Operating System: fedora linux 5 PHP Version: 5.1.6 New Comment: Since doing a fresh install of Fedora 6. This is occuring on all my SQLite databases (using PDO). Previous Comments: ------------------------------------------------------------------------ [2006-10-05 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2006-09-27 16:57:56] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip Can't reproduce. ------------------------------------------------------------------------ [2006-09-27 16:52:29] zolfi at parspooyesh dot com Description: ------------ when using SELECT statement for selecting rows of table, and using fetchAll(or fetch) method the last character of each row will be lost. Reproduce code: --------------- $db_location = "table.sqlite"; $db = new PDO("sqlite:{$db_location}"); $db->query("create table my_table (name text);"); // table is empty $query = $db->query("delete from my_table"); $query = $db->query("insert into my_table (name) values ('123')"); $query = $db->query("select name from my_table"); while ($row = $query->fetch()) { print_r($row); } Expected result: ---------------- Array ( [name] => 123 [0] => 123 ) Actual result: -------------- Array ( [name] => 12 [0] => 12 ) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=38976&edit=1