Re: BUG #10707: UPPER() does not convert non-ASCII chars

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sf(at)4js(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #10707: UPPER() does not convert non-ASCII chars
Date: 2014-06-20 16:19:48
Message-ID: 6554.1403281188@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

sf(at)4js(dot)com writes:
> Created my test1 db with utf8 charset, when using the UPPER() function, only
> ASCII chars are converted to uppercase.

> I am missing a configuration option?

No, locale (particularly lc_ctype). You set that at initdb or database
creation time.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message MauMau 2014-06-20 16:44:48 Re: Missing file versions for a bunch of dll/exe files in Windows builds
Previous Message sf 2014-06-20 14:55:38 BUG #10707: UPPER() does not convert non-ASCII chars