Adapted from http://www.depixelate.com/2008/5/24/rails-migrations-for-large-text-columns:

  create_table :foo do |t|
    ...
    t.text     :new_col, :limit => 64.kilobytes + 1
    ...
  end