1:
2:
3:
|
UPDATE bb1_threads SET `topic` = REPLACE(`topic`,"ß","ß"), `topic` = REPLACE(`topic`, "ä","ä"), `topic` = REPLACE(`topic`, "ü","ü"), `topic` = REPLACE(`topic`, "ö","ö"), `topic` = REPLACE(`topic`, "Ä","Ä"), `topic` = REPLACE(`topic`, "Ãœ","Ü"), `topic` = REPLACE(`topic`, "Ö","Ö"), `topic` = REPLACE(`topic`, "€","€");
UPDATE bb1_posts SET `posttopic` = REPLACE(`posttopic`,"ß","ß"), `posttopic` = REPLACE(`posttopic`, "ä","ä"), `posttopic` = REPLACE(`posttopic`, "ü","ü"), `posttopic` = REPLACE(`posttopic`, "ö","ö"), `posttopic` = REPLACE(`posttopic`, "Ä","Ä"), `posttopic` = REPLACE(`posttopic`, "Ãœ","Ü"), `posttopic` = REPLACE(`posttopic`, "Ö","Ö"), `posttopic` = REPLACE(`posttopic`, "€","€");
UPDATE bb1_posts SET `message` = REPLACE(`message`,"ß","ß"), `message` = REPLACE(`message`, "ä","ä"), `message` = REPLACE(`message`, "ü","ü"), `message` = REPLACE(`message`, "ö","ö"), `message` = REPLACE(`message`, "Ä","Ä"), `message` = REPLACE(`message`, "Ãœ","Ü"), `message` = REPLACE(`message`, "Ö","Ö"), `message` = REPLACE(`message`, "€","€"); |