Re: storing binary data in a "memory" database

2022-06-05 Thread Bob Sneidar via use-livecode
Oooh that may do it. I’ll try when I get the chance. Sent from my iPhone > On Jun 4, 2022, at 06:31, Brian Milby via use-livecode > wrote: > > Is this the issue? > > To pass binary data in an array element, prepend "*b" to the element's key. > > Sent from my iPhone > >> On Jun 3, 2022, at

Re: storing binary data in a "memory" database

2022-06-04 Thread Brian Milby via use-livecode
Is this the issue? To pass binary data in an array element, prepend "*b" to the element's key. Sent from my iPhone > On Jun 3, 2022, at 6:56 PM, Bob Sneidar via use-livecode > wrote: > > Hi Doc thanks for the response. I am using aes256 encryption so an ascii > hash is not viable. If this w

Re: storing binary data in a "memory" database

2022-06-03 Thread Bob Sneidar via use-livecode
Hi Doc thanks for the response. I am using aes256 encryption so an ascii hash is not viable. If this were a file based sqLite database I could perhaps change the encoding. Maybe I can with a :memory: database too! Here's my code. I have posted this before, it's an incredibly useful handler. If y

Re: storing binary data in a "memory" database

2022-06-03 Thread doc hawk via use-livecode
A couple of lines of code with declarations, storing, and retrieving would probably help. There also might be a UTF issue (which would be beyond me)—a hash should be in good old 6.5 bit ASCII, not something newfangled with eight or more bits. ___ us

Re: storing binary data in a "memory" database

2022-06-03 Thread doc hawk via use-livecode
bob bobbled, > 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. You shouldn’t need a BLOB for a hash. Either CHAR(), VARCHAR(), or TEXT. With the first two, you need to specify a long enough length.

Re: storing binary data in a "memory" database

2022-06-03 Thread Bob Sneidar via use-livecode
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 > wrote: > > Hi all. > > I have set up a kind of database caching metho

storing binary data in a "memory" database

2022-06-03 Thread Bob Sneidar via use-livecode
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 i