CRC32

​

Syntax

​

Bytes (scalar)

crc32(value)

​

Arguments

​

Returns

• Type: BIGINT
• Possible values: 0 through 4294967295, representing an unsigned 32-bit checksum.
• NULL behavior: NULL input returns NULL. Strings are checked as UTF-8 bytes.

​

Properties

​

Usage notes

• STRING values are converted to UTF-8 bytes. BINARY values are checked as their raw bytes.

​

Examples

​

Basic checksum

SELECT crc32('abc') AS result;

​

Empty input and NULL

SELECT crc32('') AS empty_value, crc32(CAST(NULL AS VARCHAR)) AS null_value;

​

Binary input

SELECT crc32(X'616263') AS result;

​

Related functions

• sha1
• hex