Re: sha1 function in MySql query.
> The password field is VARCHAR with length 40.
Read again ...
"If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. This avoids potential problems with trailing space removal or character set conversion that would change data values, such as may occur if you use a nonbinary string data type (CHAR, VARCHAR, TEXT)." --
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_sha1
Subject
Written By
Posted
September 07, 2021 03:20PM
September 07, 2021 03:48PM
September 07, 2021 05:26PM
September 07, 2021 07:21PM
September 08, 2021 01:13PM
September 08, 2021 03:45PM
September 08, 2021 04:33AM
September 08, 2021 10:29AM
Re: sha1 function in MySql query.
September 08, 2021 12:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.