A string is a sequence of bytes or characters.
A String is enclosed within either single quote (') or double quote (") characters.
For example,
'a string'
"another string"
A binary string has no character set or collation.
A non-binary string has a character set and collation.
String literals may have an optional character set introducer and COLLATE clause:
[_charset_name]'string' [COLLATE collation_name]
SELECT _latin1'string';
SELECT _latin1'string' COLLATE latin1_danish_ci;