Rob DiCiuccio

MySQL: fixing double-encoded UTF-8 data

Ever have double-encoded UTF-8 data in your MySQL database? Of course you have. Here’s a handy trick to quickly remedy that sticky situation, via MySQL command-line tools:

mysqldump -h DB_HOST -u DB_USER -p DB_PASSWORD --opt --quote-names --skip-set-charset --default-character-set=latin1 DB_NAME > DB_NAME-dump.sql

mysql -h DB_HOST -u DB_USER -p DB_PASSWORD --default-character-set=utf8 DB_NAME < DB_NAME-dump.sql

That’s it! No scripts required.

Source: Odd, Even, Odd, Even…

Git Is Simpler Than You Think

nfarina:

It was about one year ago that we switched to Git. Previously, we used Subversion, through the Mac app Versions, which (rightly) holds an Apple Design Award.

I made the executive decision to leave our comfy world of Versions because it seemed clear that Git was winning the Internet. There was much grumbling from my teammates, who were busy enough doing actual work thank you very much.

But I pressed forward. We signed up for accounts on Github. We learned how to type 'git push' and 'git pull'. We became more confident. Git is just like any other source control system! But it wasn’t long before one of our devs called me over to look at a…situation.

Read More

18th & Valencia, SF

Meanwhile, in Germany