storing binary data in a "memory" database

[Bob Sneidar]

Right now I am querying for the hash directly from the source database when I need it. Just curious why sqLite cannot handle storing an encrypted string. 

Bob S


> On Jun 3, 2022, at 14:29 , Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hi all. 
> 
> I have set up a kind of database caching method where I take currently selected data in my display form and save it in a :memory: database. Everything works EXCEPT that the value for the encrypted hash is getting corrupted. It's not coming back the way it was stored. It looks like it is getting cut off. 
> 
> How should I define a column in sqLite that is going to properly store and retrieve a password hash? Simply using a BLOB type doesn't do it. 
> 
> Bob S
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode