Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

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




Status: Planned
Comments
Mariyaali
Microsoft Employee

Thanks for raising this issue. We are actively investigating further.

fbcideas_migusr
New Member
Status changed to: Planned