mysql adapter should create table with default charset

mysql allows this :
CREATE TABLE DEFAULT CHARSET=utf8

But a pristine install of mysql does not create utf8 databases by default,
and it's a common source of error. (postgres and sqlite3 do use utf8 on most
up-to-date installs).
More annoying, many clients do not have the permissions to create the database,
and since it's Latin1 by default, they end up with ??? and complain.
Therefore this little patch would be great :

require 'active_record/connection_adapters/abstract_adapter'
module ActiveRecord
  module ConnectionAdapters
    class MysqlAdapter < AbstractAdapter
      def create_table(table_name, options = {}) #:nodoc:
        encoding = @config[:encoding]
        if encoding
          options = options.reverse_merge(:options => "DEFAULT CHARSET=#{encoding}")
        end
        super(table_name, options.reverse_merge(:options => "ENGINE=InnoDB"))
      end
    end
  end
end

However, i'm not sure the encoding strings allowed by activerecord match the ones of mysql.