Mr Lucky
Well-known member
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:
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
So I have lots of … and ’
The first of those I can easily fix with a query:
SQL:
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
Last edited: