Simple MSSQL query failing...Why?

Anon

I just can't figure it out. I have a text column in MSSQL7 and the client wants to update it via copy-and-paste. The text can inlcude both single and double quotes. I've used Oracle and MySQL with the exact same code, but now, on MSSQL, it breaks. Here is where the update dies:

set BODY="my \"book\" it\'s good"

If there were only single quotes, the query works. Cany anyone offer a suggestion as to why this isn't working? I use magic_quotes, as I'm too lazy to code addslashes() every time I'd need it, so the quotes are automagically escaped.

Thanks muchly,
Biggus

Anon

My guess is that Micro$ofts SQL is actually more SQL-92 compliant in this case and demands single quotes around a text string:

set BODY='my \"book\" it\'s good'

Does this work?

Anon

I tried that, too. When I use single quotes, the query dies at the apostrophe, even though it's escaped. Maybe I'll just give up and do a str_replace on the single quotes, swapping in the HTML code for them.

[deleted]

Not every database uses a slash to escape, some use the 'double-up' method where you simply put every escaped-quote in there twice, like
set body='this isn''t a quote';

google is great for finding these things out.

Anon

Vincey,

if you'd looked at my postings, you'd see that I indicated that the query was successful with one type of quote at at time, escaped (lookout...) with a backslash. For some reason I am not able to have the same type of quote (double or single) inside the string as is surrounding the string in the query, regardless of whether it's escaped.

As far as google goes, I looked through the first couple hundred sites/blurbs, but if you want to sift through the 3000+ google results (which all talk about addslashes as the answer), go ahead.