Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Category:
Coding, syntax & commands
>>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.
That thought did cross my mind :(
I figured that before I went to that extreme, I'd ask around.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only