One solution i thought could work was to convert the char into int and use
mode 128 to bring then in the range of ascii caracters
but it consists of negative number as well which complicate thing
difficult to fit in the ascii space
++++
when convert same int to char get different char
A sample example is ::
int test = -90; // == to '▓' when char converted to int
char letter = '▓';
printf("Char TO int %c \n",(int)letter); // -90
printf("int TO Char %c \n",(char)test); //ª WHICH is not = '▓'
PLZ can someone provide a solution -- to store encrypted text in a database
- SQLite??
On Mon, Apr 1, 2013 at 2:42 PM, Jevin Sonut <j.so...@gmail.com> 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 <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
>
>
>
>
--
From:-
Shanil J.S
