XF 1.2 Replacing " With " (or Fixing Quotation Marks)

[imno007]

After converting from SMF, I've discovered that every single quotation mark (double quote) on my Xenforo forums has been replaced with "

Is there a simple database query I could run that would replace every instance of " with quotation marks?

Thanks

 

[Jeremy]

Use Kier's resource to replace post content. If it requires RegEx:
(")

Replace it with " and you should be good.

 

[Paul B]

If it's a simple replacement for identical content, you could just use a query.

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Take a backup before doing so though.

 

[imno007]

Thanks, Brogan, will give it a try soon and see how it goes.