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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 13:51:13
Message-ID: 10249.1470664273@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Farber <alexander(dot)farber(at)gmail(dot)com> writes:
> More info:
> # \l+

> Name | Owner | Encoding | Collate | Ctype |
> -----------+---------+----------+---------+-------+
> postgres | user1 | UTF8 | C | C |
> template0 | user1 | UTF8 | C | C |
> | | | | |
> template1 | user1 | UTF8 | C | C |
> | | | | |
> words | user1 | UTF8 | C | C |

Well, there's your problem: in C locale, only the standard ASCII letters
will be transformed by upper/lower.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-08-08 13:53:21 Re: Should a DB vacuum use up a lot of space ?
Previous Message Pekka Rinne 2016-08-08 08:57:07 Re: upgrade to repmgr3