Skip to main content
Version: 0.0.1

CRC32

Categories: String, Binary

CRC32

Returns a cyclic redundancy check value of a binary string.

Syntax​

CRC32(expression varbinary) → varchar​

  • expression: The string to encode.

Examples

{{< codeheader "CRC32 example" >}}

SELECT CRC32('Dremio')
-- 2212276499

{{< codeheader "CRC32 example" >}}

SELECT CRC32(100)
-- 595022058

{{< codeheader "CRC32 example" >}}

SELECT CRC32(-100)
-- 2938773767

{{< codeheader "CRC32 example" >}}

SELECT BIN(null)
-- null