Brian Beach • 4/25/2021

Case-sensitivity in Aurora PostgreSQL

This technical article analyzes case-sensitivity challenges when migrating from SQL Server to PostgreSQL, specifically in Aurora. It details the use of deterministic and non-deterministic collations introduced in PostgreSQL 12 for case-sensitive and case-insensitive comparisons, demonstrates their behavior with queries and LIKE/ILIKE operators, and argues that the CITEXT extension remains a superior solution despite native support.

0 comments

#database #postgresql #case sensitivity