Hi Thomas, I have tried
sqlite> select * from loc_configuration; 0|0|18|52|86|4|24|22|51|116|39|15|0|0|0|0|0|0|0|0|0|0|0|0 The blob is the one before the last one, and the length is the very last one The serials are second, third , fourth and fifth columns. sqlite> UPDATE loc_configuration SET loc_authorization_code_length = 18, loc_authorization_code = X'000102030405060708' WHERE loc_serial_0=0 AND loc_serial_1=18 AND loc_serial_2=52 AND loc_serial_3=86; sqlite> select * from loc_configuration; 0|0|18|52|86|4|24|22|51|116|39|15|0|0|0|0|0|0|0|0|0|0||0 I get no response or error from sqlite3. Roman On Tuesday 04 April 2006 05:21 pm, Thomas Chust wrote: > On Tue, 4 Apr 2006, Roman wrote: > > [...] I am using sqlite3 on am embedded platform. I am using c++ to > > enter data. I have BLOB field, and I do not know how to enter hex values > > from a data string. [...] > > Hello, > > if you need to put BLOB data verbatim into an SQL statement, SQLite3 > supports syntax like > INSERT INTO blobs VALUES(X'deadbeef'); > You just denote the BLOB as a string of an even number of hexadecimal > characters preceded by an 'X' or 'x'. > > In many cases it may be a better idea, though, to put placeholders into > your SQL statement and to use sqlite3_bind_blob to load the BLOB data for > statement execution. > > cu, > Thomas
