BOB10's avatar
BOB10
New Member
3 years ago
Status:
Planned

HashBytes returns incorrect length in Fabric DW

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




Recent ideas