How to get case-sensitive data with rails query

Question

Assuming there is a community who has both "apple" and "APPLE" tags.

Then if I execute this with the param "apple"

@communities = Community.joins(taggings: :tag).where(tags: { name: params[:tag] })

In result page, 2 sets of the same community come appears.
It's probably because it's fetching with the params[:tag] for both upper case and lower case.

How can I strict this and make it not like search? I want case-sensitive and complete match.

Rahul Tapali · Accepted Answer · 2013-01-30 18:19:36Z

4

Try enclosing attribute name in binary.

 @communities = Community.joins(taggings: :tag).where(['binary(tags.name) = ?', params[:tag]])

edited Jan 30, 2013 at 18:19

answered Jan 30, 2013 at 17:50

Rahul Tapali

10.2k7 gold badges33 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Foo Over a year ago

Thanks!!! both of them didn't work. so I took the idea from your binary() then I did @communities = Community.joins(taggings: :tag).where('binary(tags.name)' => params[:tag]) but it still won't work:(

Foo Over a year ago

@communities = Community.joins(taggings: :tag).where('tags.name' => params[:tag]) This works but this fetches both "apple" and "APPLE"

Rahul Tapali Over a year ago

I am not getting what is joins (taggings: :tag) means.. can you explain bit?

Foo Over a year ago

I'm using the gem called "acts_as_taggable". Usually this could be called easily by the dault method of this gem. just like this Community.tagged_with(params[:tag]) However it won't work for few tags somehow. I found out it's because of collation thing.

Foo Over a year ago

this gem automatically created 2 tables. but no model. tables are "Taggings" and "Tags". In taggings, it has "taggable_type, ""taggable_id", and "tag_id" this is polymorphic

|

Collectives™ on Stack Overflow

How to get case-sensitive data with rails query

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related