This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
HASHBYTES returns the wrong length on Fabric DW as compared to SqlPool or SqlDbEngine
For example
SELECT len(HASHBYTES('MD5', 'a'))
returns 10 on Fabric which is not as expected but returns 16 on other SQL Editions.
Note that the length issue affects all algorithms not just MD5
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.