Many MySQL encryption and compression functions return strings that may contain arbitrary byte values. To store these results, use
BLOBBinary string data type. This will avoid using non-binary string data types (
TEXT)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 follows
collation_connectionSystem variables are determined.
To be continued