Hello, I first appreciate a lot the work ! Bravo !!
We found the functions very usefull to change from characters to numeric data without lookups nor joins, in a repeatable way, accross several databases !!!
We tested the xf_GetHash64 on 550 millions real keys with only 47 collisions. After we look on theses collisions, we found the collisions was caused by very similar strings that had an upper case i turkish (İ) . This is the only caracter we had problem with.
That return :
Do you have any idea why this caracter causing an issue ?
We use :
SQL 2016 SP2: 13.0.5026
The instance and database collation is SQL_Latin1_General_CP1_CI_AS
CLR function compiled with Visual Studio 2015 and .net 4.5