datatype text in mysql (Ruby on Rails)

Question

In development I used sqlite3 and I was writing a blog application. So for the blog articles, I had datatype text which worked fine. I was able to write really long articles, never had a problem. Switch over to production using MySQL and now my articles are getting truncated after around 250 characters.

Does anyone know what I need to do and/or change to get MySQL to behave like sqlite3 was, allowing really large bodies of text?

Thank you.

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

Are you using t.string :your_field instead of t.text :your_field in the migration file? — PeterWong
– PeterWong, Commented Apr 11, 2011 at 6:18
wow, so sorry to waste your guys time, i had just recently rewrote the app, and made that mistake second time around. Soooo sorry guys, thanks anyways though! — Ben
– Ben, Commented Apr 11, 2011 at 6:33

maček · Accepted Answer · 2011-04-11 07:24:03Z

7

May be you should replace

t.string   :body

with

t.text   :body

edited Apr 11, 2011 at 7:24

maček

78k37 gold badges172 silver badges200 bronze badges

answered Apr 11, 2011 at 6:21

thekindofme

3,86629 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

coder_tim Over a year ago

Yes, I think this is right, Rails treats a "string" as a "varchar(255)" for mysql. Using "text" will allow more characters.

Rodrigo César Calle Castillo · Accepted Answer · 2022-06-26 01:17:05Z

0

You must to change:

 t.text :body #change here

You can find more information about data type comparisons here

edited Jun 26, 2022 at 1:17

answered Jun 26, 2022 at 1:15

Rodrigo César Calle Castillo

11 bronze badge

Collectives™ on Stack Overflow

datatype text in mysql (Ruby on Rails)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related