[adminer-tracker] [ adminer-Bugs and Features-3417674 ] Files uploaded into BLOB columns are truncated

[SourceForge.net <no...@so...>]

Bugs and Features item #3417674, was opened at 2011-10-03 08:25
Message generated for change (Tracker Item Submitted) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3417674&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQLite
Group: 3.3.3
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Jakub Vrána (jakubvrana)
Summary: Files uploaded into BLOB columns are truncated

Initial Comment:
When uploading a file into any BLOB column in SQLite3 the file is truncated at first NUL byte. This makes image uploads unusable.

Problem is in SQLite escaping function $connection->quote($string) - SQLite truncates the string at first NUL byte.

Solution is to modify quote function to check for NUL byte and convert string to its hex representation using X'...' literal and pack('H*',$data) function.



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3417674&group_id=264133