HASHTYPE_MD5

Purpose

This function computes a hash value by using the MD5 algorithm (128 Bit).

Syntax

hashtype_md5::=

HASHTYPE_MD5

Usage Notes

  • Return values have data type HASHTYPE(16 byte).
  • The data types of the input parameters are significant. That is why HASHTYPE_MD5(123) is different to HASHTYPE_MD5('123').
  • Multiple input expressions are concatenated (in their internal byte representation) before the hash value is computed.

    • Generally, HASHTYPE_MD5(c1,c2) is not similar to HASHTYPE_MD5(c1||c2).

  • The function returns NULL if all input expressions are NULL.

Example

Copy 
SELECT HASHTYPE_MD5('abc');