Clean encoding problems

UPDATE table SET column = REPLACE(column, '“', '“'); UPDATE table SET column = REPLACE(column, '†', '”'); UPDATE table SET column = REPLACE(column, '’', '’'); UPDATE table SET column = REPLACE(column, '‘', '‘'); UPDATE table SET column = REPLACE(column, '—', '–'); UPDATE table SET column = REPLACE(column, '–', '—'); UPDATE table SET column = REPLACE(column, '•', '-'); UPDATE table SET column = REPLACE(column, '…', '…');

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.