Edit report at https://bugs.php.net/bug.php?id=62361&edit=1
ID: 62361
Updated by: fel...@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
