Is the backslash \ counted as a character in MySQL?
if i have a table which has columns with fi开发者_如何学编程xed lenght, Will mySQL count the backslashes as characters?
Example :
people(name[10],age[3])
If i store in the name column a MySQL escaped value like : Blahblah\'s
Will MySQL cut it at the quote?
Thanks
No, escape characters do not add the length of char
or varchar
string, because escape characters are not stored at all.
CREATE TABLE a (name char(5));
INSERT INTO a VALUES ('1234567890');
INSERT INTO a VALUES ('12\'345678');
SELECT * FROM a;
+-------+
| name |
+-------+
| 12345 |
| 12'34 |
+-------+
2 rows in set (0.00 sec)
精彩评论