Syntax
------ 
SHA1(str), SHA(str)
 
Description
----------- 
Calculates an SHA-1 160-bit checksum for the string str, as
described in
RFC 3174 (Secure Hash Algorithm).
 
The value is returned as a string of 40 hex digits, or NULL
if the argument was NULL. As of MariaDB 5.5, the return
value is a nonbinary string in the connection character set
and collation, determined by the values of the
character_set_connection and collation_connection system
variables. Before 5.5, the return value was a binary string.
 
Examples
-------- 
SELECT SHA1('some boring text');
+------------------------------------------+
| SHA1('some boring text') |
+------------------------------------------+
| af969fc2085b1bb6d31e517d5c456def5cdd7093 |
+------------------------------------------+
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/sha1/