Daniel Black gave the solution :
I confirm that SQLLite supports BLOB, that is to say "binary storage".
http://www.sqlite.org/datatype3.html
It is strange that it does not work...
Apart from that, dummy storage of binary data as ascii is trivial (no
need of any sophisticated encoding such as b64) :
just store hexa number "8F" as two ascii characters "8" and "F".
Ok, then you need 2 bytes to store 1, so a 200% expansion,
but is storage space really a problem in your case ?
I am surprised of a so big thread for a so trivial question.
Encrypted or not is not the problem.
Or I mean "encrypt/decrypt" and storage of keys is another pb. Some
directions have also been given in the thread for that.
Best,
Pierre
Le 01/04/2013 14:15, Salz, Rich a écrit :
ØPLZ can someone provide a solution -- to store encrypted text in a
database - SQLite??
You might have gotten all the help that the volunteers who read this
list are going to give you. If you look through the archives, you
might see that people here generally do not post complete source code
solutions. Code fragments, and suggestions of techniques and where to
look are far more common.
The comment “base 64 doesn’t work” means you are doing something
wrong. If the OpenSSL API is giving you problems, perhaps
http://base64.sourceforge.net/b64.c will be more useful to you.
/r$
--
Principal Security Engineer
Akamai Technology
Cambridge, MA
