Character Sets and rake db:test:prepare

As far as I can tell, if I’m using MySQL and I set the character set
and collation on my databases when I create them (e.g. CREATE DATABASE
project_development CHARACTER SET utf8 COLLATION utf8_general_ci),
when I run db:test:prepare it’ll lose that information because
db:test:purge drops and recreates my database without bothering to
check what my character set and collation actually are.

This seems like something other people would have tripped over by now,
but google searches aren’t turning anything up. Thoughts?

  • Geoffrey