I've tried searching for awhile and haven't had any luck. I'm able to store and retrieve blob data using inserts and the hex encoded literals like this
INSERT INTO rolled (roll1, roll2) VALUES (X'000106350000000000',X'00000000000000'); But when I try to use the .import method the values get imported as the string "X'...." instead of the hex blob value and don't get pulled out correctly. Do I need to use a different format for .import or do I just have to use inserts for blobs? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
