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
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
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
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
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.
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
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