Nick,
I couldn't figure out why my tables were being created with a default
collation of utf8_bin. But with some digging I found out that the
activerecord-jdbc-adapter differs from the default Rails behavior for the
mysql adapter.
jdbc:
def create_table(name, options = {}) #:nodoc:
super(name, {:options => "ENGINE=InnoDB CHARACTER SET utf8 COLLATE
utf8_bin"}.merge(options))
end
Rails native:
def create_table(table_name, options = {}) #:nodoc:
super(table_name, options.reverse_merge(:options => "ENGINE=InnoDB"))
end
Would you entertain changing this to match the native Rails behavior?
Thanks,
Alex