Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux

Hello

> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alexander Farber
> Sent: Montag, 8. August 2016 10:12
> Cc: pgsql-general <pgsql-general@postgresql.org>
> 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:

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