LiveCode Forums.

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

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