Hi guys,
I recently switched to a new server where I believe the magic_quotes_gpc is ON by default. I think that my old server was OFF by default.
This is of course causing backslashes all over my database in my text field. I had coded applications with the addslashes() functions based on the old server.
Now that I'm on the new server I'm going to code some "smarter" applications to actually detect the magic_quotes setting before applying the addslashes().
So here is my REAL PROBLEM. I have double sets of slashes that I want to remove from my tables. Suggestions on their removal would be appreciated. I figured I could do it with PHP but would prefer doing it straight in a query.
What is making this problem worse is that in some cases I have triple slashes or NO Slashes. Yes you heard correctly, it appears that addslashes() was working some of the time and not others. I have no idea why since this is the only piece of code adding to this table and it should have been acting 100% consistently for every insert into MySQL.
I am very worried about the data that appears to have NO backslashes. How can my database integrity stay intact if there are no backslashes to help it discern between the actual columns of data? If I did a dbdump and reload wouldn't those words without backslashes (like don't or isn't) play havoc with the reload process?
Thanks,
-Chris
