Just notice that by default queries like:
DB[:person].filter(:first_name.like("%#{q}")
will generate this query:
SELECT * from person where first_name like binary '%queryvalue%"
Which does case sensitive. In order to get case insensitive you must
give the option also.
DB[:person].filter(:first_name.like("%#{q}%", :case_insensitive =>
true))
SELECT * from person where first_name like '%queryvalue%"
The cheat sheet here threw me off a little because it did not mention
the default is insensitive:
http://sequel.rubyforge.org/rdoc/files/doc/cheat_sheet_rdoc.html
Here's the doc page that explains the option:
http://sequel.rubyforge.org/rdoc/classes/Sequel/SQL/StringExpression.html#M000087
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
