I have the following problem.
I encrypt data and put it into a field of an SQLite database
The encrypted code is as below
E5BB0C163CE26A9D57BBDCF6B8CBAB12
However if I try to retrieve this field with 'put revDataFromQuery(,,DatabaseID,tSQL) into tRec'
the field with the encrypted data only returns the following characters: E5BB0C163CE26A9D57BBDCF6B8.
Additional information:
File type is defined as Char (120) . Just to make sure the field was not set to small.
It is the last field in the table (might be useful to know?)
When I look in the database with SQLite Expert professional I see that the encrypted data has been written correct into the database.
Maybe I need to use a different field type?
Anybody knows a solution for this problem ?
Thanks
Paul
Problem retrieving encripted characters in SQLITE
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 722
- Joined: Thu Sep 11, 2014 1:49 pm
- Location: The Netherlands
-
- Posts: 722
- Joined: Thu Sep 11, 2014 1:49 pm
- Location: The Netherlands
Re: Problem retrieving encripted characters in SQLITE
After some tests I solved the problem .
Instead of declaring the field as as Char (120) I declared it as Text.
This solved the problem!
Hope this saves sombody else some time
Kind regards,
Paul
Instead of declaring the field as as Char (120) I declared it as Text.
This solved the problem!
Hope this saves sombody else some time
Kind regards,
Paul