M
M
Maxim Barulin2015-09-30 16:45:15
SQL
Maxim Barulin, 2015-09-30 16:45:15

Where can I get crc32 calculation function for Ms Sql Server?

Hey Habr!
Tell me where can I find a function for calculating crc32, such that the calculated value matches the one that produces crc32 in php? Google did not help, I found this stackoverflow.com/questions/331157/does-sql-server... but the returned value in sql is -662733300, and in php - 3632233996.
SELECT CHECKSUM('test') gives out generally -1854252673... Both systems are x64.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Daemon23RUS, 2015-09-30
@Slavenin999

I vote for CRC32("test")= 0xd87f7e0c
and something tells me that there is a "magic" connection between the numbers -662733300 and 3632233996, I would call it signed/unsigned

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question