I need to jump in here. VFP isn't unicode, but the OS is. In some circumstances VFP is tricked by the OS and does some "translation" by its own so you have to make absolutely sure this doen't happen. Storing the binary encoded as hexbinary is one way to do it; another would be to define the encrypted column as varbinary. According to VFP help, "No code page translation is performed on *Varbinary* data." And that's the whole point of it. VFP will use the actual value, without trying to be smart.
On Thu, Jan 12, 2012 at 1:02 AM, Tracy Pearson <[email protected]>wrote: > "MB Software Solutions, LLC" <[email protected]> > wrote: > > > From Craig's vfpencryption page under the Remarks from the HASH > >function > >( > http://www.sweetpotatosoftware.com/spsblog/2009/08/09/MajorVFPEncryptionUpdate.aspx > ): > > > > > > > >---------------------------------------------------------- > >The hash is returned as a series of binary characters. However, it is > >more common to see hashes in a hexBinary format. This can be > >accomplished in Visual FoxPro by taking the return of the Hash() > >function and sending it in as a parameter to the STRCONV() function. > >For > >example: > > > >?STRCONV(Hash("Some String"), 15) && hexBinary Hash > >---------------------------------------------------------- > > > > > >I guess I'm wondering why not just store the HASH value returned? It's > > > >all cryptic anyway. I mean, if you're using this to save passwords, > >what's the difference how you store it? You're still comparing the > >person's entered password HASHed against what's stored in the database, > > > >right? > > > >-- > >Mike Babcock, MCP > >MB Software Solutions, LLC > >President, Chief Software Architect > >http://mbsoftwaresolutions.com > >http://fabmate.com > >http://twitter.com/mbabcock16 > > > > If I remember correctly, that function returns the string with some chr(0) > on the end. > The strconv() will shorten the text. Otherwise, I don't see a difference. > -- > Tracy Pearson > PowerChurch Software > Sent with K-9 Mail. > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAH=cqdjmmavqbscekmx7sddgnp682rmxtlxires5kbhxri6...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
