Rails 3 Migration with longtext

ruby-on-rails migration ruby-on-rails-3
dennismonsewicz picture dennismonsewicz · Dec 14, 2010 · Viewed 33.4k times · Source

I am needing to change a column type from text to longtext in my Rails script, but can't find anything on how to do this.

Has anyone ran across this?

Thanks! Dennis

Answer

Chuck Callebs picture Chuck Callebs · Dec 14, 2010

The text type handles tinytext, text, mediumtext, and longtext for MySQL, if that's what you're using. Just specify the upper bound using :limit => ...

Example:

change_column :articles, :body, :text, :limit => 4294967295

The default value of limit is 65535, as expected.

1 to 255 bytes: TINYTEXT
256 to 65535 bytes: TEXT
65536 to 16777215 bytes: MEDIUMTEXT
16777216 to 4294967295 bytes: LONGTEXT

The MySQL documentation can be found here.

Related questions

Rails: How can I rename a database column in a Ruby on Rails migration?

I wrongly named a column hased_password instead of hashed_password. How do I update the database schema, using migration to rename this column?

Read More
Rails DB Migration - How To Drop a Table?

I added a table that I thought I was going to need, but now no longer plan on using it. How should I remove that table? I've already run migrations, so the table is in my database. I figure rails …

Read More
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