From: | sf(at)4js(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #10707: UPPER() does not convert non-ASCII chars |
Date: | 2014-06-20 14:55:38 |
Message-ID: | 20140620145538.2634.85619@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 10707
Logged by: FLAESCH Sebastien
Email address: sf(at)4js(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-06-20 16:19:48 | Re: BUG #10707: UPPER() does not convert non-ASCII chars |
Previous Message | Michael Paquier | 2014-06-20 14:17:13 | Re: Missing file versions for a bunch of dll/exe files in Windows builds |