SQLite-是否可以通过insert语句插入BLOB？-SQLite-IsitpossibletoinsertaBLOBviainsertstatement?

16  

If you really, really want to you can use a very long hex literal as a blob literal:

如果你真的，真的想要你可以使用一个很长的十六进制文字作为blob文字：

insert into memes(img, name) values(X'0102030405060708090a0b0c0d0e0f', '1.jpg')

However, this is usually a bad idea; instead, go look at parameterised queries. They will let you compile a statement once using placeholders instead of actual values, and then reuse it many times, filling in the placeholders as needed:

然而，这通常是一个坏主意;相反，去看参数化查询。它们将允许您使用占位符而不是实际值编译语句，然后多次重复使用，根据需要填充占位符：

SQLiteStatement p = sqlite.compileStatement("insert into memes(img, name) values(?, ?)");

byte[] data = loadData("1.jpg");
p.bindBlob(1, data);
p.bindString(2, "1.jpg");
p.execute();

byte[] data = loadData("2.jpg");
p.bindBlob(1, data);
p.bindString(2, "2.jpg");
p.execute();

(Warning --- code not tested.)

（警告---代码未经测试。）

In general you should be using parameterised queries everywhere, as they're a sure-fire way to avoid SQL injection attacks, plus are usually easier and clearer. Assembling SQL queries by glueing strings together should be avoided at all costs.

通常，您应该在任何地方使用参数化查询，因为它们是避免SQL注入攻击的可靠方法，而且通常更容易和更清晰。应该不惜一切代价避免通过将字符串粘合在一起来组装SQL查询。

0  

Your data table has some invisible word which you can not see. Check your db file with the db tools like navicat for sqlite. Please pay attention to the error word in the table.

您的数据表有一些您看不到的隐形字。使用dbic工具检查db文件，例如navicat for sqlite。请注意表中的错误字。