Binary types include binary, VARBINARY, BIT, Tinyblob, BLOB, Mediumblob, Longblob binary (M) types, save bytes instead of characters, no character set limit, byte number is M, allow length of 0 ~m a fixed-length binary string. Less than the maximum specified length of space by the "\" complement, the query should also include "\", otherwise not found. Comparisons are made by byte rather than by character (char), which is simple and fast compared to characters, by character (char), and binary is case-sensitive. The VARBINARY (M) type, which allows a variable-length binary string of lengths of 0~m, actually occupies the actual length plus 1. Comparisons are made by byte rather than by character (char). "\" is not included in this type. Problem: Binary type is not sufficient to replace, char type of less than the number of bytes with what instead?
MySQL binary type