Base64 never fails for any binary data. Something's wrong in your steps. As far as I understand you are using Qt, right? In Qt you have direct methods in QByteArray class for converting to Base64 String and retrieving back from it.
On Mon, Apr 1, 2013 at 4:12 PM, Jevin Sonut <[email protected]> wrote: > 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 <[email protected] > > 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 [email protected] >> Automated List Manager [email protected] >> > > > > -- > > From:- > Shanil J.S > > > >
