Rails validates_uniqueness_of across multiple columns with case insensitivity

ruby-on-rails scope case-insensitive validates-uniqueness-of
Jimmy picture Jimmy · Feb 7, 2010 · Viewed 7.4k times · Source

I have a model that has two fields, which I will call first_name and last_name, and I want to make sure that the combination of the two are case-insensitively unique. I've gotten halfway there by using this:

validates_uniqueness_of :first_name, :scope => :last_name

The problem is that the uniqueness check seems to be case sensitive, even though the documentation says it should be case insensitive by default. So given an existing record:

{ :first_name => 'John', :last_name => 'Smith' }

This will be allowed:

{ :first_name => 'JOHN', :last_name => 'SMITH' }

As well as any additional record where there is any variation of case in either the first or last name. Why are these records being allowed? How can I enforce case insensitive uniqueness across both fields together?

Answer

Luke Francl picture Luke Francl · Feb 7, 2010

Did you try validates_uniqueness_of :first_name, :scope => :last_name, :case_sensitive => false?

The documentation says it's true by default.

(I think the link you gave is to some outdated documentation. IIRC, the default for this did change in the last couple of years.)

Related questions

Rails includes with scope

I have a model called Author. An author has many Articles. Articles have a scope called .published that does: where(published: true). I want to load the author, with the published articles. I tried: Author.includes(:articles.published).find(params[:…

Read More
How to use unscoped on associated relations in Rails3?

I have a default scope on products due to information security constraints. class Product < ActiveRecord::Base has_many :photos default_scope where('visible = 1') end In my associated Photo model, however, I also have to find products that should …

Read More
Argument Error: The scope body needs to be callable

I'm working through the 'Ruby On Rails 3 Essential Training' and have received a problem when using name scopes. When finding records and using queries withing the Rails console everything went smoothly until I tried to use a name scope in …

Read More