MySQL Single Quotes

[ZJRT]

My web host, in its infinite wisdom, decided to disable the ability to use escaped single quotes in any MySQL query. So, anything like this:

Code Select Expand


INSERT into TEST(test) VALUES('What\'s this?');


wouldn't work. So, is there any way to get around this? The prospect of reprogramming every database query to use the

Code Select Expand


'


code instead of the escaped single quote is more than a little daunting. Any help here would be greatly appreciated.

[H]

Although I'm not a wiz with SQL are you just replacing \ with ' ?

If so then you can just use a batch find and replace

[kegobeer]

You should only have to edit one thing: the db_query function.  You could scan the input string for ' and for \' and replace them with '.  Unfortunately, that could also cause problems with some queries that might need the '.  Hopefully a dev can comment on my suggestion.