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

sf@4js.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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Hello Amit,

Yes I found the problem, in fact I have created my db with:

$ createdb test1 -E utf8

Seems that I need to specify the locale explicitly with 9.4:

$ createdb test1 -E utf8 -l en_US.utf8

I think I did not use the -l option in 9.3.2 ...
Or maybe it defaults to the current LC_* settings in the shell and I used different
settings when I created the database with 9.3.2... I wonder...

So sorry for reporting this as a bug, it's ok now.

Thanks for the answer!
Seb

On 06/20/2014 05:59 PM, Amit Langote wrote:

On Sat, Jun 21, 2014 at 12:51 AM, Amit Langote <amitlangote09@gmail.com> wrote:

On Fri, Jun 20, 2014 at 11:55 PM, <sf@4js.com> wrote:

The following bug has been logged on the website:

Bug reference: 10707
Logged by: FLAESCH Sebastien
Email address: sf@4js.com
PostgreSQL version: 9.4beta1
Operating system: Linux Debian (3.14-1-amd64 #1 SMP Debian 3.14.4-1)
Description:

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?

I have also 9.3.2 installed, and the characters are converted to uppercase.

test1=# SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname
= 'test1';
pg_encoding_to_char
---------------------
UTF8
(1 row)

test1=# select upper('âãäåçèéêëô') ;
upper
------------
âãäåçèéêëô
(1 row)

What locale is your database using? Is it 'C'?

--
Amit

Or what does following say:

SELECT datctype FROM pg_database WHERE datname = 'test1';

--
Amit

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs