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

Hello

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