When inserting binary data into a string column (such as a BLOB column), the following characters must be represented by escape sequences : String : Data Types MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Data Types
»
String
»
When inserting binary data into a string column (such as a BLOB column), the following characters must be represented by escape sequences
NUL
Represent this character by .
Represent this character by \.
'
Represent this character by '.
"
Represent this character by ".
Related Scripts with Example Source Code in same category :
Character or String Data Types
Strings
MySQL recognizes the following escape sequences.
To include quote characters within a string
A " inside a string quoted with " may be written as "".
Precede the quote character by an escape character (\).
A single quotation inside a string quoted with double quotation needs no special treatment.
A double quotation inside a string quoted with single quotation needs no special treatment.
Hexadecimal Values
String comparisons normally are case-insensitive
Leave a Comment / Note
Name (required)
email (will not be published) (required)
Website
Vérification
Refresh
Enter code
Verification is used to prevent unwanted posts (spam). .
MySQL TUTORIALS
Data Types
»
String
BIGINT
INT
Bit
INTERVAL
BLOB
Introduction
Boolean
MEDIUMINT
Char Varchar
NULL
Date
Set
DATETIME
SMALLINT
Decimal
String
Double
TEXT
ENUM
TIME
FLOAT
Timestamp
FULLTEXT
TINYINT
Hexadecimal
YEAR
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View