insert binary data into sqlite

[sattu]

Hi everyone,
I am using qt 4.7.I am trying to store binary data.My binary data is present in QByteArray.
Can any one tell me how to insert ? What is the create and insert statement ?

thanks

[high_flyer]

http://www.qtcentre.org/threads/3972...highlight=BLOB

[stampede]

I think you can use BLOB datatype for the data field, so create could look like:

CREATE TABLE test( data BLOB NOT NULL );

CREATE TABLE test( data BLOB NOT NULL );

To copy to clipboard, switch view to plain text mode 

and insert QByteArray as any other value, for example:

QByteArray bytes;
...
QSqlQuery query(db);
query.prepare("INSERT INTO test(data) VALUES(:data);");
query.bindValue(":data",bytes);
query.exec();

QByteArray bytes;
...
QSqlQuery query(db);
query.prepare("INSERT INTO test(data) VALUES(:data);");
query.bindValue(":data",bytes);
query.exec();

To copy to clipboard, switch view to plain text mode