>I'm using Craig Boyd's FLL to create a SHA-256 hash code. After I call it with HASH(m.lcHashme, 2) , it returns:
>
>"ƒ]ÊQ“öu 9/s¦«†8‚žZ¸™€Ç)ÚSìˆÅ"
>
>If I then encode it to hexBinary using STRCONV("ƒ]ÊQ“öu 9/s¦«†8‚žZ¸™€Ç)ÚSìˆÅ", 15) I get:
>
>"835DCA0E5193F675A0392F73A6AB118638829E5AB89980C729DA05538DEC88C5"
>
>The issue that I'm having is that I'm supposed to get "52e7e37b8c5f6cde8505a9d4a6324ca486d5aa13dde18cb7fa58690978343f72" because the web service that I'm going to call generates the latter. If it helps, I've been told that the web service generated the value from the hash code in bytes: 82 -25 -29 123 -116 95 108 -34 -123 5 -87 -44 -90 50 76 -92 -122 -43 -86 19 -35 -31 -116 -73 -6 88 105 9 120 52 63 114
>
>I'll be the first to admit that I'm clueless about this stuff and any assistance would be greatly appreciated.
Maybe the web service is using a hash that is actually something different from what Craig's FLL calls SHA-256? Just for grins, maybe you could spin through all the options for HASH() and see if any of the results match what you're supposed to get.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
