Generate md5 for Chinese in SQL Server
SELECT LOWER(CONVERT(VARCHAR(32), HASHBYTES(‘MD5’, ‘a’), 2)); Result : 0cc175b9c0f1b6a831c399e269772661 This is OK. SELECT LOWER(CONVERT(VARCHAR(32), HASHBYTES(‘MD5’, ‘啊’), 2)); Result : 795d6a1c51f0ac4b0856f5cac1846f3f The correct result is 04c16ff7b157d4b4702bb24aa62651a5 Why do I get a wrong result? Please solve my question, thanks! md5 New contributor Jack W is a new contributor to this site. Take care in asking for clarification, commenting, […]
Generate md5 for Chinese in sqlserver
SELECT LOWER(CONVERT(VARCHAR(32), HASHBYTES(‘MD5’, ‘a’), 2));
result : 0cc175b9c0f1b6a831c399e269772661
This is OK.