GabyYYZ (8/10/2009)
Is this due to the way checksum parses unicode vs. binary?
Seems so:
-- 0x3600 3700 3400
SELECT (CONVERT(VARBINARY, N'674'));
SELECT CONVERT(BINARY(2), UNICODE(N'6')) -- 0x0036
SELECT CONVERT(BINARY(2), UNICODE(N'7')) -- 0x0037
SELECT CONVERT(BINARY(2), UNICODE(N'4')) -- 0x0034
The binary representation is byte-reversed.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi