Use PreparedStatement setBytes method. No need to convert to base64. Ulric
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Kelly Sent: November 23, 2009 10:47 PM To: [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
