Bug #62361 [Opn->Ver]: SQLite3::escapeString

Edit report at https://bugs.php.net/bug.php?id=62361&edit=1 ID: 62361 Updated by: felipe@php.net Reported by: lgynove at 163 dot com Summary: SQLite3::escapeString -Status: Open +Status: Verified Type: Bug Package: SQLite related Operating System: windows xp PHP Version: 5.3.14 Block user comment: N Private report: N New Comment: In fact actually escapeString() method is not binary-safe. Previous Comments: ------------------------------------------------------------------------ [2012-06-23 07:33:03] lgynove at 163 dot com null ------------------------------------------------------------------------ [2012-06-19 05:28:29] lgynove at 163 dot com Description: ------------ this bug in sqlite3,not sqlite. use picture file (*.jpg) is not work use *.txt is work ok if use sqlite function (sqlite_escape_string) is work ok! Test script: --------------- $db = new sqlite3(dirname(__FILE__) . '/test.sqlite'); $str = file_get_contents('d:/www/test.jpg'); echo strlen($str),"\n"; $str = $db->escapeString($str); echo strlen($str),"\n"; $str = file_get_contents('d:/www/test.txt'); echo strlen($str),"\n"; $str = $db->escapeString($str); echo strlen($str),"\n"; Expected result: ---------------- 5000 5000 35 35 Actual result: -------------- 5000 4 35 35 ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=62361&edit=1