change column to allow null

rubyonrails-talk
1

how do I change the column in a table to allow null?

I have

    change_column :docs, :orga, :null

in my migration file but I get an error:

Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null DEFAULT '' NOT NULL' at line 1: ALTER TABLE `docs` CHANGE `orga` `orga null DEFAULT '' NOT NULL

2

Actually, I had :null=> true

3

Actually, I had :null=> true

how do I change the column in a table to allow null?

I have

change\_column :docs, :orga,    :null

If you check the docs for change_column you will see that you need the column type even if it has not changed change_column :docs, :orga, whatever_type_it_is :null=>true

Colin

4

cool thanks