Re: Can't insert the '&' character ...

[Rick James]

Eh?

mysql> INSERT INTO abc VALUES ('Me, myself & I'),
                              ('Me, myself \& I');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> SELECT hello, HEX(hello) FROM abc WHERE hello LIKE 'Me%';
+----------------+------------------------------+
| hello          | HEX(hello)                   |
+----------------+------------------------------+
| Me, myself & I | 4D652C206D7973656C6620262049 |
| Me, myself & I | 4D652C206D7973656C6620262049 |
+----------------+------------------------------+
2 rows in set (0.00 sec)

The "26" near the end of the HEX is for "&".

The backslash is ignored when it is in front of a character that does not need escaping.

Please show us the text that is failing to be inserted. And the HEX of it if possible.