How to Use MySQL Conversion Functions - CONVERT, CAST, BINARY
This tutorial covers how to use Conversion Functions (Binary, Cast, Convert) in MySQL. ... Binary type forces the comparison to be done byte by byte rather than character by character. Also it causes the comparison to be case sensitive even if the column ...