Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6230: strange changes in behavior of string functions - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6230: strange changes in behavior of string functions
Date
Msg-id 28423.1317180642@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6230: strange changes in behavior of string functions  ("Dmitry Ryabov" <dmitry-ryabov@mail.ru>)
List pgsql-bugs
Tree view 
"Dmitry Ryabov" <dmitry-ryabov@mail.ru> writes:
> In the version 9.1 I was surprised to find that the function "upper" now is
> not working as before. For example:

> select upper ('SISTEM AYGıTLARı') = 'SISTEM AYGITLARI'

> in postgresql 9.0 returns true, but in postgresql 9.1 - false.

It sounds like you didn't use the same locale settings when creating
your 9.1 database.  Check LC_CTYPE and LC_COLLATE settings.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Dmitry Ryabov"
Date:
Subject: BUG #6230: strange changes in behavior of string functions
Next
From:
Date:
Subject: Re: Problems with ENUM type manipulation in 9.1