1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
UPDATE tt_content SET
bodytext = REPLACE(bodytext, '’', '’'),
bodytext = REPLACE(bodytext, '©', '©'),
bodytext = REPLACE(bodytext, '–', '–'),
bodytext = REPLACE(bodytext, '
', ' '),
bodytext = REPLACE(bodytext, '“', '“'),
bodytext = REPLACE(bodytext, 'ß', 'ß'),
bodytext = REPLACE(bodytext, 'Ãœ', 'Ü'),
bodytext = REPLACE(bodytext, 'ü', 'ü'),
bodytext = REPLACE(bodytext, 'ä', 'ä'),
bodytext = REPLACE(bodytext, 'Ä', 'Ä'),
bodytext = REPLACE(bodytext, 'Ö', 'Ö'),
bodytext = REPLACE(bodytext, 'ö', 'ö'),
bodytext = REPLACE(bodytext, 'á', 'á'),
bodytext = REPLACE(bodytext, 'ó', 'ó'),
bodytext = REPLACE(bodytext, 'é', 'é'),
bodytext = REPLACE(bodytext, 'Ã-', 'í'),
bodytext = REPLACE(bodytext, '€', '€'),
bodytext = REPLACE(bodytext, 'ž', 'ž'),
bodytext = REPLACE(bodytext, '…', '…'),
bodytext = REPLACE(bodytext, '‘', '‘'),
imagecaption = REPLACE(imagecaption, '’', '’'),
imagecaption = REPLACE(imagecaption, '©', '©'),
imagecaption = REPLACE(imagecaption, '–', '–'),
imagecaption = REPLACE(imagecaption, '
', ' '),
imagecaption = REPLACE(imagecaption, '“', '“'),
imagecaption = REPLACE(imagecaption, 'ß', 'ß'),
imagecaption = REPLACE(imagecaption, 'Ãœ', 'Ü'),
imagecaption = REPLACE(imagecaption, 'ü', 'ü'),
imagecaption = REPLACE(imagecaption, 'ä', 'ä'),
imagecaption = REPLACE(imagecaption, 'Ä', 'Ä'),
imagecaption = REPLACE(imagecaption, 'Ö', 'Ö'),
imagecaption = REPLACE(imagecaption, 'ö', 'ö'),
imagecaption = REPLACE(imagecaption, 'á', 'á'),
imagecaption = REPLACE(imagecaption, 'ó', 'ó'),
imagecaption = REPLACE(imagecaption, 'é', 'é'),
imagecaption = REPLACE(imagecaption, 'Ã-', 'í'),
imagecaption = REPLACE(imagecaption, '€', '€'),
imagecaption = REPLACE(imagecaption, 'ž', 'ž'),
imagecaption = REPLACE(imagecaption, '…', '…'),
imagecaption = REPLACE(imagecaption, '‘', '‘'); |
