Mick Perez

Tag: mysql

  • Strange characters after importing a MySQL dump

    —

    by

    Mick
    in

    I recently imported a mysql dump of my wikkawiki to this server and somehow strange characters appeared in my generated pages, for instance € got replaced by € To solve this problem, run underneath script on all tables / fields affected. UPDATE `table` SET `field`=REPLACE(`field`,”á”,”á”); UPDATE `table` SET `field`=REPLACE(`field`,”ä”,”ä”); UPDATE `table` SET `field`=REPLACE(`field`,”â”,”â”); UPDATE `table`…