mysql

[_*charset_name*]'*string*' [COLLATE *collation_name*]

e.g.

charset_name

defaults to character_set_connection system variable (shown via

show variables like 'character_set_connection'; )