NULL value cannot be inserted because of a PRIMARY KEY constraint.
'a\'a' is incorrect. Single quotation mark should be escaped using another single quote: 'a''a'.
Some databases (e.g., MySQL) has a mode that allows a backslash escape character, but it is better not to rely on this.