Read more

Case sensitivity in PostgreSQL

Tobias Kraze
August 01, 2016Software engineer at makandra GmbH

PostgreSQL, unlike MySQL, treats strings as case sensitive in all circumstances.

Illustration web development

Do you need DevOps-experts?

Your development team has a full backlog? No time for infrastructure architecture? Our DevOps team is ready to support you!

  • We build reliable cloud solutions with Infrastructure as code
  • We are experts in security, Linux and databases
  • We support your dev team to perform
Read more Show archive.org snapshot

This includes

  • comparison with = and LIKE
  • collision detection in unique indexes

Usually this is fine, but some strings (like emails and usernames) should typically be treated as case insensitive.

There are a few workarounds available:

Probably the best approach is to just convert emails (and usernames) to lowercase within Rails. Popular authentication libraries (like Clearance and Devise) already do this for you.

Posted by Tobias Kraze to makandra dev (2016-08-01 12:06)