Alexander Farber <alexander.farber@xxxxxxxxx> writes: > More info: > # \l+ > Name | Owner | Encoding | Collate | Ctype | > -----------+---------+----------+---------+-------+ > postgres | user1 | UTF8 | C | C | > template0 | user1 | UTF8 | C | C | > | | | | | > template1 | user1 | UTF8 | C | C | > | | | | | > words | user1 | UTF8 | C | C | Well, there's your problem: in C locale, only the standard ASCII letters will be transformed by upper/lower. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general