Mysql data type (Ruby on Rails)

Question

In development, I used sqlite3, and I wrote a blog application. So, for the blog articles, I had a data type text that worked fine. I could write really long articles, and I had no problems. Switch to production using MySQL, and now my articles are truncated after 250 characters.

Does anyone know what I need to do and / or change to make MySQL behave the way sqlite3 was, allowing really big bodies of text?

Thanks.

db / schema.rb:

ActiveRecord::Schema.define(:version => 20110307222323) do create_table "articles", :force => true do |t| t.integer "user_id" t.string "title" t.string "body" t.datetime "created_at" t.datetime "updated_at" t.integer "category_id" t.string "url" end end 

Answer 1

Maybe you should replace

 t.string :body 

with

 t.text :body