From: | "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org> |
---|---|
To: | "'Alexander Farber'" <alexander(dot)farber(at)gmail(dot)com> |
Cc: | "'pgsql-general'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux |
Date: | 2016-08-08 08:15:28 |
Message-ID: | 018201d1f14d$0c35e710$24a1b530$@swisspug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Farber | 2016-08-08 08:20:46 | Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux |
Previous Message | Alexander Farber | 2016-08-08 08:11:38 | Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux |