Changing MySQL database encoding

For some time now, I had a pending task of converting the latin1-encoded MySQL database powering this site into utf8. I finally managed to do it after getting some advice from the kind people at a Vienna WordPress meetup.

The essence is that out of all the methods suggested in the official documentation, what worked best for me was dumping all the data to a text file, marking up and encoding it as utf-8 in a text editor and then importing it into a new database (instead of working on the production DB) that we point the wp-config.php file to after everything is verified.

Continue reading

Fine-looking R plots

While strolling through a friend’s copy of The Economist today, admiring a very coherent visual identity they chose, I remembered reading this blog post about R having such a theme a while back.

Lead by curiosity, I gave it a try.

Blue makes for a soothing colour to present such shocking data, don’t you think?

Quick instructions… Continue reading