XF 1.5 Queries to fix character issues after vbulletin import

[Mr Lucky]

Too late to go back, this is an old import and I obviously set the charset incorrectly.

So I have lots of … and ’

The first of those I can easily fix with a query:

UPDATE `xf_post`
SET `message` = replace(message, '…', '...')

But there is a problem with ’ as it needs to be replaced with a hyphen and obviously that won't work as it messes with the single quotes of the query.

EDIT: as Andy points out below, not a hyphen, I meant apostophe.

Does anyone know how to fix this please? (I checked the Post find and replace regex discussion, and although I found references to ’ I could not find a definitive regex so I want to fix this with a SQL query.

Thanks

 

[AndyB]

But there is a problem with ’ as it needs to be replaced with a hyphen and obviously that won't work as it messes with the single quotes of the query.

It's not clear what the problem is. What hyphen?

 

[Mr Lucky]

It's not clear what the problem is. What hyphen?

Sorry brain fart, it's not a hyphen it is an apostrophe.

The apostrophe between the single quotes breaks the query:

UPDATE `xf_post`
SET `message` = replace(message, '’', ''')

 

[Paul B]

Escape it with a slash.

 

[AndyB]

UPDATE `xf_post`
SET `message` = replace(message, '’', "'")