Ruby on Rails
HowtoAvoidHavingTheWordNULLAppearInYourFormFields

When using MS SQL with rails, rails will show the word NULL in text fields and text areas in your forms for any field that allows nulls and has no default value.

Solution: include a default value of ’’ (empty value) in your migrations for any field that allows nulls. for example:

create_table :foo do |t|
  t.column :bar, :string, :default => ''
  t.column :wombat, :string, :default => ''
end

I’m unaware if this problem occurs in other DBMSs. Anyone else have any idea?