MySQL makes stuff easy 2

How to convert old html-symbols to utf-8 automatically in MySQL?

i did it with REPLACE():

UPDATE `articles` SET `title` = replace(`title`,'ä','ä');

UPDATE `articles` SET `title` = replace(`title`,'ö','ö');

UPDATE `articles` SET `title` = replace(`title`,'ü','ü');

… worked with all my old tables :)

Tags: , , ,
Posted in MySQL |

This entry was posted on Monday, July 6th, 2009 at 9:56 am and is filed under MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
PHP SQLite3 support«

Leave a Reply

Anti-Spam Protection by WP-SpamFree