Article From:https://www.cnblogs.com/chenhuanBlogs/p/9968154.html

Many MySQL encryption and compression functions return strings that may contain arbitrary byte values. To store these results, useVARBINARYorBLOBBinary string data type. This will avoid using non-binary string data types (CHARVARCHARTEXT)Removing trailing spaces or character set conversions can potentially change data values. Encryption functions such as MD5 (), SHA1 () return 16-digit strings with character sets and sorting. Rules are as followscharacter_set_connectionandcollation_connectionSystem variables are determined.

To be continued

Link of this Article: MySQL Encryption Compression

Leave a Reply

Your email address will not be published. Required fields are marked *