Strings : String « Data Types « MySQL Tutorial






  1. MySQL Tutorial
  2. Data Types
  3. String

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;








10.21.String
10.21.1.Character or String Data Types
10.21.2.Strings
10.21.3.MySQL recognizes the following escape sequences.
10.21.4.To include quote characters within a string
10.21.5.A " inside a string quoted with " may be written as "".
10.21.6.Precede the quote character by an escape character (\).
10.21.7.A single quotation inside a string quoted with double quotation needs no special treatment.
10.21.8.A double quotation inside a string quoted with single quotation needs no special treatment.
10.21.9.When inserting binary data into a string column (such as a BLOB column), the following characters must be represented by escape sequences:
10.21.10.Hexadecimal Values
10.21.11.String comparisons normally are case-insensitive