<= MariaDB 10.7


From MariaDB 10.8



Computes a cyclic redundancy check (CRC) value and returns a 32-bit unsigned value. The result is NULL if the argument is NULL. The argument is expected to be a string and (if possible) is treated as one if it is not.

Uses the ISO 3309 polynomial that used by zlib and many others. MariaDB 10.8 introduced the CRC32C() function, which uses the alternate Castagnoli polynomia.

MariaDB starting with 10.8

Often, CRC is computed in pieces. To facilitate this, MariaDB 10.8.0 introduced an optional parameter: CRC32('MariaDB')=CRC32(CRC32('Maria'),'DB').


SELECT CRC32('MariaDB');
| CRC32('MariaDB') |
|       4227209140 |

SELECT CRC32('mariadb');
| CRC32('mariadb') |
|       2594253378 |

From MariaDB 10.8.0

SELECT CRC32(CRC32('Maria'),'DB');
| CRC32(CRC32('Maria'),'DB') |
|                 4227209140 |

See Also


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.