I am working on importing a large food database.
So many problems seem to come up with branded food names.
Some have + signs
There is T.G.I.F. Friday’s with a single quote in the name
Then some food names have double quotes "
I am pulling the names using PHP/SQL. Wrapping it up in JSON, then parsing that JSON.
I guess I will try to escape characters on the PHP/SQL query part and see if that fixes things.
This post is half ranting, half asking: what is your experience with escaping these trouble characters? (As it were)