Recent changes to 133: cppDb with sqlite3: blob data inserted as text instead of blobhttps://sourceforge.net/p/cppcms/bugs/133/2014-08-20T15:06:54.372000ZRecent changes to 133: cppDb with sqlite3: blob data inserted as text instead of blobcppDb with sqlite3: blob data inserted as text instead of blob2014-08-20T15:06:54.372000Z2014-08-20T15:06:54.372000ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net27c725ed76f3af15629833af4f7dd0fe16054e28<div class="markdown_content"><p>When trying to insert blob data in sqlite3 throw cppDb, data is actually stored as text rather than blob. Changing the following code in sqlite3_backend.cpp seems to fix the issue, but I am not sure if there are side effects to this:</p>
<p>virtual void bind(int col,std::istream &v) <br />
{<br />
...<br />
check_bind(sqlite3_bind_text(st_,col,tmp.c_str(),tmp.size(),SQLITE_TRANSIENT));<br />
}</p>
<p>replaced with<br />
check_bind(sqlite3_bind_blob(st_,col,tmp.c_str(),tmp.size(),SQLITE_TRANSIENT));</p></div>