Md5

The Md5() function hashes one or more text strings into one hexadecimal text value which is hashed using the MD5 algorithm.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Hashed values cannot be decoded, usually you check an incoming value against a known value that you hash yourself and check if both values are identical, to verify correctness without knowing the actual value.

Returns a 128-bit hexadecimal representation of an MD5 hashed value. Returns unknownif one of the parameter values is unknown or outside the common valid boundaries.

Syntax

Md5(text1[, text2] )

Md5("") => ""

Md5("text1", "text2") => "d5730d50d4d8d8dd01f055e633fe35b9"

Md5("The quick brown fox jumps over the lazy dog.") => "e4d909c290d0fb1ca068ffaddf22cbd0"

Md5(file)

Md5( [some-specific-file] ) => "a858b7711ea69692d7981bf888de963a"

Parameters

Name	Type	Required	Description
text1	text	☑️	a text
text2	text		another text
file	file	☑️	a file