You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

SHA1

Hashes the given string or binary data using the so-called secure hash algorithm, version 1. SHA1 has been deprecated as a means of securely signing data. It is present in MemSQL mainly for backwards compatibility and for systems which require a “good enough” hashing function and can tolerate collisions. For a more secure hash function, see [SHA2].

Syntax

SHA1(plaintext)
SHA(plaintext)

Arguments

  • plaintext: the data to hash.

Return Type

40 lower case hexadecimal digits corresponding to the 160-bit binary hash value.

Examples

memsql> select sha1('ohai');
+------------------------------------------+
| sha1('ohai')                             |
+------------------------------------------+
| dca51952447d80bd35bf631bc21f06648798b7e0 |
+------------------------------------------+

Related Topics