Solve the character set problem reported by executing SQL statements in the mysql drip _ 02 Program

Solve the character set problem reported by executing SQL statements in the mysql drip _ 02 Program
Execute in the program"SELECT t. EVENT_TYPE_ID FROM RATABLE_EVENT_TYPE t WHERE t. NAME = 'end-of-account Fee Transfer event'"Error reported
Error code: Invalid 1267 mixed character set.
Error message: mix of collations (gbk_bin, IMPLICIT) and (latin1_swedish_ci, COERCIBLE) for operation '='
Solution: Use the binary () function to unify the character set.SELECT t. EVENT_TYPE_ID FROM RATABLE_EVENT_TYPE t WHERE t. NAME =Binary ('End-of-account Fee Transfer event')