BINARY attribute for the weak

From Hashmysql
Jump to: navigation, search

There is a big difference when you are talking about BINARY as a type and BINARY as an attribute. BINARY as an attribute causes ordering to be based on the underlying character codes. Which basically means that everything will be ordered in a case-sensitive fashion. Otherwise, everything will be ordered alphabetically.

Source: lokus AND http://dev.mysql.com/doc/mysql/en/CHAR.html