Dear,
We would like to hash certain data in our recipients table, but do notice that the returned hash isn't the right one when we use the SHA256 or SHA512 expression. For MD5 the returned result is however the right one.
We've checked the conversion in numerous ways (cf. https://dencode.com/hash --> UTF8, UTF16, ... CRLF, LF, ...) and investigated a lot of deviations (capitals vs regular letter, spaces, ...) already.
Example string: 1ZZ1234
SHA256 | db33faa6dc66525db69058bd1b0b0a4257aa881218adc83581a2c5bc368be170 |
SHA256 generated by Adobe Campaign | 5c12c786e84b2b7f8bf4b89e5c88ded8bf6a4fd05908b63050945f9fa5b6322d |
MD5 | 29e110be8987fd8403f2940a617e668d |
MD5 generated by Adobe Campaign | 29e110be8987fd8403f2940a617e668d |
SHA512 | 38c700cd0dbcda40ba1b48605eb2485eca529bc2d2e4c04b21b15539a14098c764bc6f7693a984420dc19cfea8610c9fe485585cfc41dfcc52cc48e3eed71e19 |
SHA512 generated by Adobe Campaign | e14c06f1c43bb65ee8487f54528a8278bbdd96582b9f23a93901fef04e3f6ed664a85308f56c5360413791bd384c14e2b0adb81b988c6c0fb05cf06530278919 |
We are using the following functions:
- Md5Digest()
- Sha256Digest()
- Sha512Digest()
Does anyone experienced the same or know what might be at the roots of the wrong hash generation by Adobe Campaign?
If you are a campaign user, do you get the same wrong hash?
Kind regards,
Wesley
解決済! 解決策の投稿を見る。
トピックはコミュニティのコンテンツの分類に役立ち、関連コンテンツを発見する可能性を広げます。
表示
返信
いいね!の合計
Please refer to this thread for the exact solution: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/sha256-and-sha512-...
Regards,
Sukrity
表示
返信
いいね!の合計
Please refer to this thread for the exact solution: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/sha256-and-sha512-...
Regards,
Sukrity
表示
返信
いいね!の合計
Hi WesleyXP,
I also found the issue.
After my test, I found that normally when we use SHA256 hash on online website or elsewhere.
That function will perform on varchar datatype.
But in Adobe Campaign because of Adobe mapping datatype String as nvarchar (in unicode case).
Refer to this website: https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/schema-re...
Then when we generate with SHA256 function it will has data based on nvarchar --> not varchar.
In this case, it return incorrect value.
In my case, I try to modify the datatype on SQL create table page while using update database structure.
Modify the target field from 'nvarchar' to 'varchar' -> And 'YESSSSS!!!' -> I can use SHA256 function as normally.
Warning: However, varchar may not support some language.
表示
返信
いいね!の合計