Home
MySQL Tutorial
Introduction
Select Query
Database
Table
Table Join
Subquery
Insert Update Delete
Logic Operator
View
Data Types
Procedure Function
Cursor
Trigger
Date Time Functions
Comparison Functions Operators
Aggregate Functions
Cast Functions Operators
Control Flow Functions
Encryption Compression Functions
Information Functions
Math Numeric Functions
Miscellaneous Functions
String Functions
Regular Expressions
Data Dictionary
MySQL Utilities
Privilege
String « Data Types « MySQL Tutorial
MySQL Tutorial
Data Types
String
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