New versions: Dev (3.15) | Latest (3.14) | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | Old versions: 3.7 | 3.6 | 3.5 | 3.4 | 3.3
MD5
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The MD5()
function calculates the MD5 hash of a given string.
SELECT md5('hello');
create.select(md5("hello")).fetch();
The result being
+----------------------------------+ | md5 | +----------------------------------+ | 5d41402abc4b2a76b9719d911017c592 | +----------------------------------+
Dialect support
This example using jOOQ:
md5("hello")
Translates to the following dialect specific expressions:
-- AURORA_MYSQL, AURORA_POSTGRES, COCKROACHDB, MARIADB, MEMSQL, MYSQL, POSTGRES md5('hello') -- ORACLE lower(standard_hash('hello', 'MD5')) -- SQLDATAWAREHOUSE lower(convert(VARCHAR(32), hashbytes('MD5', CAST('hello' AS varchar(8000))), 2)) -- SQLSERVER lower(convert(VARCHAR(32), hashbytes('MD5', CAST('hello' AS varchar(max))), 2)) -- ACCESS, ASE, BIGQUERY, DB2, DERBY, EXASOL, FIREBIRD, H2, HANA, HSQLDB, IGNITE, INFORMIX, REDSHIFT, SNOWFLAKE, SQLITE, -- SYBASE, TERADATA, VERTICA /* UNSUPPORTED */
(These are currently generated with jOOQ 3.15, see #10141)
Feedback
Do you have any feedback about this page? We'd love to hear it!