10. 21. 2. Strings |
|
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;
|
|