views:

167

answers:

1

according to mysql certification guide, comparisons between binary collation vs binary strings are different because comparisons in binary collation is done per character vs per byte in binary strings. but what difference does that give?

A: 

Bump. I can't see how they differ. Ultimately the comparison is based on bytes even if you are looking at more than one series of bytes at a time. I assume however that there is a specific scenario than benefits from the difference?