Hello! I don't understand why do some people have a bad time with conversions, if they want to store BLOB in SQLite. The official FAQ also recommends that one should use any kind of conversion to convert binary data to a format that is suitable for SQLite:
http://www.sqlite.org/faq.html#q12 In my opinion, this is completely unnecessary. I'm using it via PHP, putting the binary data into the sqlite_escape_string function and it may go into the query: <? dl("sqlite.so"); $conn=sqlite_open(":memory:"); sqlite_query($conn,"create table bindata(data blob)"); $bin=str_repeat(chr(0),5).chr(255).chr(0).chr(255).str_repeat(chr(0),5); sqlite_query($conn,"insert into bindata(data)values('".sqlite_escape_string($bin)."')"); $handle=sqlite_query($conn,"select * from bindata"); $result=sqlite_fetch_array($handle); echo "<pre>".bin2hex($result["data"])."</pre>"; ?> Does anybody know about this solution? Bye! Lay --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
