Redmine

i meant when default database encoding is Latin, rails encoding utf8
makes sure table are utf8, except for the ones that corresponds to the data
loaded by load_default_data task.

Jérémy Lal wrote:

i meant when default database encoding is Latin, rails encoding utf8
makes sure table are utf8, except for the ones that corresponds to the data
loaded by load_default_data task.

Rails doesn't do nothing, saying encoding: utf8 in the database.yml just makes sure rails sends the data as UTF-8 to the DB engine. If the DB engine is configured with latin1 as collation, rails can't do anything against it.

Could you please describe what exactly you have done to get that error on a pristine install?

Hi,
this is probably not a bug, sorry.
Still, rake db:create or db:migrate could use
CREATE TABLE roles (...) DEFAULT CHARACTER SET utf8;
and that would solve the problem of mysql db created in latin1 (by default on most mysql installs).

The trouble is postgres, sqlite has been defaulting to UTF8 for quite a long time,
while mysql has still some weird encoding as its default. So most postgres or sqlite
users won't be bothered, while many mysql users will.
The following patch (added to config/initializers/) could help,
by creating tables with default charset utf8, regardless of the character_set_database.

require 'active_record'
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

The patch consists in adding the three lines [if ... end].

Feel free to close the bug as invalid,
Jérémy.

Agreed, done here :
http://rails.lighthouseapp.com/projects/8994/tickets/5830-mysql-adapter-should-create-table-with-default-charset

Regards,
Jérémy.