What effects does using a binary collation have?

What effects does using a binary collation have?

mysql database binary string-comparison collation

mysql

Inserting and selecting UUIDs as binary(16)

mysql binary uuid

mysql

Storing MySQL GUID/UUIDs

mysql binary guid uuid

mysql

Varbinary vs Blob in MySQL

mysql binary blob

mysql

Insert hex values into MySql

mysql binary hex

mysql

MySQL binary against non-binary for hash IDs

mysql string binary

mysql

Convert hex to binary in MySQL

mysql sql binary hex

mysql

mysql case sensitive in utf8_general_ci

php mysql binary collation

mysql

Convert binary string to bigint in MySQL?

mysql hash binary md5 bigint

mysql