Hello > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Alexander Farber > Sent: Montag, 8. August 2016 10:12 > Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx> > Subject: Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux > > Thank you for the replies. > On CentOS 7 Linux with pgdg 9.5.3 the lower() method works and I have: > > # \l > List of databases > Name | Owner | Encoding | Collate | Ctype | > -----------+----------+----------+-------------+-------------+ > postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > | | | | | > template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > | | | | | > words | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | Well yes, anogher collation and ctype. I found an easier way to use the workaround after create collation: kofadmin@test.localhost=> select lower(('И'::text collate "en_US")) ; lower ------- и (1 row) Maybe other more expert than me on this topic will suggest better solution. Bye Charles -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
