MySQL char (len) binary and varchar (len) binary intent

A query to make you understand

Select ' abc ' = ' abc ' as IgnoreCase, binary ' abc ' = ' abc ' as Notignorecase;

High (installed) level (forced) a bit

Select if (' abc ' = ' abc ') = 1, ' equal ', ' not Equal ') as IgnoreCase, if ([binary ' abc ' = ' abc ') = 1, ' equal ', ' not equal ') a s notignorecase;

Yes, MySQL is not case-sensitive by default, so in some query commands we may encounter this problem, the value before the binary modified data will be read in accordance with the binary (ASCII code) to operate, so there is no choice ' abc ' to the ' ABC ' also queried the issue of

MySQL char (len) binary and varchar (len) binary intent