Hexadecimal Values : String « Data Types « MySQL Tutorial






  1. MySQL Tutorial
  2. Data Types
  3. String
mysql>
mysql> SELECT x'4D7953514C';
+---------------+
| x'4D7953514C' |
+---------------+
| MySQL         |
+---------------+
1 row in set (0.00 sec)

mysql>








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