Ruby on Rails

I get a strange result upon querying DB records in which the column
(VARCHAR) is set to NULL by default

the generated query is :
SELECT * FROM `contents` WHERE `contents`.`type` IN ('Article') AND
(state <> 'draft');

when contents.state is NULL, then the record IS NOT selected
when contents.state is'' ( empty ) then the record is selected
( obviously when set to any other value too..)

is it the 'standard' behavior ? ( so I'll have to change the
default ..)
or should I modify /add anything in the query ?

thanks for feedback

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.