- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi wodnicki,
Based on new offline feedback we got, we concluded that Adobe Campaign is adding "N" in front of the string value before hashing it. It does this for each unicode string. The result is a different hash than expected.
What Adobe Campain does:
lower(convert(varchar(64), HashBytes('SHA2_256'), N'1ZZ1234'), 2))
What you would expect:
lower(convert(varchar(64), HashBytes('SHA2_256'), '1ZZ1234'), 2))
This explains the difference between both hashes.
Wesley
Views
Replies
0 Likes
Total Likes