Edit report at https://bugs.php.net/bug.php?id=62361&edit=1
ID: 62361
User updated by: lgynove at 163 dot com
Reported by: lgynove at 163 dot com
Summary: SQLite3::escapeString
Status: Open
Type: Bug
-Package: SQLite
+Package: SQLite related
Operating System: windows xp
PHP Version: 5.3.14
Block user comment: N
Private report: N
New Comment:
null
Previous Comments:
------------------------------------------------------------------------
[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