Advanced topics

COLLATE and String Comparison: SQL Server vs PostgreSQL Differences

Case-sensitive sorting and comparison change between T-SQL and Postgres. Understand SQL_Latin1_General_CP1_CI_AS and ICU.

SQL Server uses COLLATE per column or expression. PostgreSQL uses collation per column (defined at CREATE) or COLLATE in the query — with different catalogs (libc vs ICU in PG 15+).

Case-sensitive comparison in PostgreSQL

SELECT email FROM users
WHERE email COLLATE "C" = lower(@email);

Analisador de Impacto

Case-sensitive login that works in SQL Server may fail in Postgres. Test uniqueness rules before go-live.

Abrir Análise de Projeto →