Posted by bill on 07/16/07 10:35

I created and loaded a database.
The first three fields are id, first_name and last_name
I used addslashes on the first and last names.
Here is a portion of the SQL dump that I took for backup. I have
concerns about record 47 because of the single quote in the name.

Will this dump reload ?

47, 'Sean', 'O''Kelly', NULL, NULL,

It appears that SQL is using a double quote rather than escaping
the single quote.

As usual, after reassuring me, a pointer to a reference would be
adequate.

Thanks

bill

[Back to original message]