> (VAR)BINARY

Close [0]: (VAR)CHAR BINARY, which is its own type, uses the `_bin` collation for the column or table character set. (VAR)BINARY stores binary strings, and uses the `binary` character set and collation.

In fairness, the amount of options, gotchas, and WTF involved with collations in any DB is mind-boggling.

[0]: https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.htm...

I just know that I was sitting converted uuid and was getting collisions on different binary values. This was admittedly a couple decades ago though.

By converted it was legacy records where the original int value was injected to uuid format. This was then stored in a binary field as a primary key.