Geht ziemlich schnell Sonderzeichen zu reparieren in MySQL! Scheiß Encoding! ;)
UPDATE `table` set `column`= REPLACE(`column`,"ß", "ß"), `column`= REPLACE(`column`, "ä", "ä"), `column`= REPLACE(`column`, "ü", "ü"), `column`= REPLACE(`column`, "ö", "ö"), `column`= REPLACE(`column`, 'Ä', 'Ä'), `column`= REPLACE(`column`, "Ãœ", "Ü"), `column`= REPLACE(`column`, "Ö", "Ö"), `column`= REPLACE(`column`, '€', '€');
Thank you very much, just what I need!
Great stuff, still needed ;)
Great job!
Thanks a LOT!
Vielen Dank, immer wieder hilfreich! :-)