Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I noticed something odd in the way Uniqueness is worded when creating a new field.

The two radio buttons are worded as:

  • Treat "ABC" and "abc" as duplicate values (case insensitive)
  • Treat "ABC" and "abc" as different values (case sensitive)

enter image description here

Surely, if "ABC" and "abc" are treated as duplicate values, they'd be case sensitive (i.e. sensitive to the case the user uses)? And if "ABC" and "abc" are treated as different values, they'd be case insensitive (i.e. insensitive to whether or not the user uses "abc" or "ABC")?

Seems like a typo on Salesforce's side or am I misunderstanding something here?

share|improve this question
up vote 7 down vote accepted

I think you may be misunderstanding.

"Treat "ABC" and "abc" as duplicate values" is case insensitive because it ignores (i.e. is insensitive to) the case the user uses when determining if it is a duplicate value.

"Treat "ABC" and "abc" as different values" is case sensitive because it takes into account (i.e. is sensitive to) the case the user uses when determining if it is a duplicate value.

share|improve this answer
Thanks, I was probably thinking about it too much. It's still worded pretty horribly if you ask me! – Poet Feb 16 at 10:41
I agree to a degree. I think it would be clearer if they just dropped the case insensitive/sensitive parts. – Alex Tennant Feb 16 at 10:44
Where it says "Do not allow duplicate values" then says "Treat "ABC" and "abc" as duplicate values (case insensitive)" is probably where I've gotten mixed up. – Poet Feb 16 at 10:55

No this is not the typo from salesforce side

  • Treat "ABC" and "abc" as duplicate values means no matter what's the case of characters so its case insensitive
  • Treat "ABC" and "abc" as different values means case of character matters here so its case sensitive


String  str = 'Test';
str.equalsIgnoreCase('test'); //will return true - case insensitive
str.equals('test'); //will return false - case sensitive
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.