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

Reply via email to