Collections:
CRC32() - Cyclic Redundancy Check 32-Bit
How to calculate the 32-bit CRC (Cyclic Redundancy Check) value using the CRC32() function?
✍: FYIcenter.com
CRC32(str) is a MySQL built-in function that calculates the 32-bit CRC (Cyclic Redundancy Check) value of a given character string and returns it as an integer. For example:
SELECT CRC32('MySQL'), HEX(CRC32('MySQL')); -- +----------------+---------------------+ -- | CRC32('MySQL') | HEX(CRC32('MySQL')) | -- +----------------+---------------------+ -- | 3259397556 | C24675B4 | -- +----------------+---------------------+ SELECT CRC32('123456789'), HEX(CRC32('123456789')); -- +--------------------+-------------------------+ -- | CRC32('123456789') | HEX(CRC32('123456789')) | -- +--------------------+-------------------------+ -- | 3421780262 | CBF43926 | -- +--------------------+-------------------------+
Reference information of the CRC32() function:
CRC32(str): crc Calculates the 32-bit CRC (Cyclic Redundancy Check) value of a given character string and returns it as an integer. Arguments, return value and availability: str: Required. The character string to be processed. crc: Return value. The 32-bit CRC value as an integer. Available since MySQL 4.0.
⇒ MD5() - Calculating MD5 Hash
⇐ COMPRESS() - Compressing Data
2023-12-19, 244🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...