* of this, some test are lost from UTF-8 version, such as Turkish * dotted and undotted 'i'. SELECT getdatabaseencoding() <> 'WIN1252' OR (SELECT count(*) FROM pg ...

An expression-level collation specification allows you to specify the collation to be applied to one expression, one comparison, or one sort operation. It appears at the end of a character expression ...

SELECT * FROM collate_test1 WHERE b COLLATE "C" >= 'bbc' COLLATE "C"; SELECT * FROM collate_test1 WHERE b COLLATE "C" >= 'bbc' COLLATE "en_US"; CREATE DOMAIN testdomain_sv AS text COLLATE "sv_SE"; ...

SQL concept they don't teach on online courses: COLLATE. COLLATE is a keyword that lets you control how text is sorted or compared. It’s especially useful when dealing with different languages or ...