Use PreparedStatement setBytes method. No need to convert to base64. Ulric
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Peter Kelly Sent: November 23, 2009 10:47 PM To: sqlite-users@sqlite.org Subject: [sqlite] Sqlite Java blob Hi, I've been tearining my hair out trying to figure out how store my image data in sqlite using Java. I think the best way to go is just store the base64 encoded string in the column, but I can for the life of me get a prepared statement for that to work. Can anybody show me how they are storing blobs in a sqlite databse? Thnaks in advance :) -- Peter _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
