How to make a Rails Migration be utf-8 instead of my default latin1

mysql ruby-on-rails-3 utf-8 migration latin1
GeekedOut picture GeekedOut · May 24, 2011 · Viewed 8k times · Source

I just checked my MySQL tables and I have default set as latin1. Is that generally the default?

How can I make it explicit for all my tables that I want the database to be utf-8?

I know there is a db configuration that can change the default, but I think there is also a way to do it per-migration. How could I permanently set my rails migrations from now on to be utf-8?

Thanks!

Answer

Olivier L. picture Olivier L. · May 24, 2011

create_table(:table_name, :options => 'ENGINE=InnoDB DEFAULT CHARSET=utf8')

Related questions

Change a column type from Date to DateTime during ROR migration

I need to change my column type from date to datetime for an app I am making. I don't care about the data as its still being developed. How can I do this?

Read More
Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on OSX

I have a standard Rails3 environment, RVM 1.2.9, Rails 3.0.5, Ruby 1.9.2p180, MySQL2 Gem 0.2.7, mysql-5.5.10-osx10.6-x86_64 Error I get when running rake db:migrate to create database is: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) config/…

Read More
Mysql 5.6 headaches on Mac OSX

Several of my colleagues and I have recently upgraded from MySQL 5.5 to MySQL 5.6 using homebrew on our Macs to test locally before upgrading our servers. Since this upgrade, we all have been experiencing intermittent MySQL errors when running our rails …

Read More