Binary attribute MySQL

When MySQL builds a table, there are three options for each field's properties: binary,unsigned,unsigned Zerofill, which functions as follows:

CHAR VARCHAR: Values are sorted and compared in a case-insensitive manner based on the default character set, unless the binary keyword is given. See the examples of binary use

MySQL query case-insensitive problem analysis and resolution

For data types
For example:
tinyint[(M)] [UNSIGNED] [Zerofill]
The signed range is 128 to 127, the unsigned range is 0 to 255.

If you specify an example for Zerofill,mysql, the unsigned property is automatically incremented for that column.
For example an int (4) example, insert a value of 4, you retrieve it, the column value will be 0004

Binary attribute MySQL