Mysql strings only get saved up to about 277 char

Question

Im using ruby on rails with a mysql db in the back. I realized, that the characters are limited up to about 277 per column entry...

How can I increase this?

Thanks, Markus

Answer 1

change_column :the_table_name, :the_column_name, :string, :limit => 1024 # where 1024 is your desired limit

Answer 2

Changing the field type from text to mediumtext would allow you to enter more characters

PK