hi, i have tried all the datatype in SQLite that can hold string and char (CHARACTER,VARCHAR,VARYING CHARACTER,NCHAR,NATIVE CHARACTER,NVARCHAR,TEXT,CLOB,BLOB)
BUT NONE have hold the encrypted string that i'm trying to Store and retieve i even tried on to store on text file but with the same result?? base 64 fail for cases where the bizzare symbol is 00x00 PLZ can anyone help - to store encrypted text generated by Openssl (EVP) to STORE in Database SQLite On Mon, Apr 1, 2013 at 8:48 AM, Daniel Black <daniel.s...@internode.on.net>wrote: > On 29/03/13 05:24, Matthias Apitz wrote: > > El día Thursday, March 28, 2013 a las 01:14:35PM -0500, Salz, Rich > escribió: > > > >> Encrypted data is not a text string, it is an array of binary octets. > You will have to do something like base64 encode/decode when treating it > as a text string. > > > > Or the OP should use a data type of the database which allows storing > > binary actets, like BLOB (Sybase) or IMAGE (Oracle) or ... depends on > > your DBS. > > > > matthias > > > > Since SQlite was mentioned that would be BLOB. > > http://sqlite.org/datatype3.html > > I've done this before with mysql and the BINARY type and requires no > conversion > ______________________________________________________________________ > OpenSSL Project http://www.openssl.org > User Support Mailing List openssl-users@openssl.org > Automated List Manager majord...@openssl.org > -- From:- Shanil J.S
