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
>