Hello > From: [email protected] > [mailto:[email protected]] On Behalf Of Alexander Farber > Sent: Montag, 8. August 2016 10:12 > Cc: pgsql-general <[email protected]> > Subject: Re: [GENERAL] 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: [email protected]=> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
