Hello jose, I compress/encrypt to a vector, then write the vector as a blob and reverse. Read the blob as a vector then reverse the process.
Monday, February 11, 2013, 1:45:34 PM, you wrote: jic> Greetings. jic> I have this table, jic> CREATE TABLE Test (login primary key, password); jic> and I would like to save zlib data using ubyte[] and also call jic> it back in. I have things like this: jic> 1. To save in SQLite, jic> cmd = jic> " UPDATE Test password = " ~ jic> cast(char[])cast(ubyte[])std.zlib.compress(cast(void[])"password") jic> " WHERE login = 'test';"; jic> This works, or at least, it saves in SQlite, but when I call it back, it does not. jic> 2. To call it in SQLite, jic> char[] passWord = jic> cast(char[])cast(ubyte[])std.zlib.uncompress(cast(void[])r[0]["password"]); jic> where r[0]["password"] is what I just SELECTED from SQlite. I jic> am getting an UTF8 error. This is a D program, so, the syntax jic> may not be known to some or all of you. However, the more jic> realistic SQLite question would be, how can I save ubyte data in jic> SQLite and also call it back. Thoughts? Comments? Jokes? :-) jic> thanks. jic> josé jic> _______________________________________________ jic> sqlite-users mailing list jic> sqlite-users@sqlite.org jic> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
