Are the automatically generated find_by_<field> model methods case insensitive? (I would presume not.)
If not, is there a way to make them do a case insensitive match, or do I need to write these by hand with sql?
Are the automatically generated find_by_<field> model methods case insensitive? (I would presume not.)
If not, is there a way to make them do a case insensitive match, or do I need to write these by hand with sql?
I believe it depends on the database. For example:
Bar.find_by_name 'Foo'
Division Load (0.002922) SELECT * FROM bars WHERE (bars."name" = 'Foo' ) LIMIT 1
Unless Rails generates different code for different databases (unlikely in this case), it just depends on how the database interprets the = operator. PostgreSQL is case sensitive and MySQL is case insensitive, for example.
If you want to insure case insensitivity:
Bar.find(:first, :conditions=>['LOWER(name) = ?', 'Foo'.downcase])