Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #6230: strange changes in behavior of string functions

BUG #6230: strange changes in behavior of string functions

From
"Dmitry Ryabov"
Date:
The following bug has been logged online:

Bug reference:      6230
Logged by:          Dmitry Ryabov
Email address:      dmitry-ryabov@mail.ru
PostgreSQL version: 9.1
Operating system:   Windows x64
Description:        strange changes in behavior of string functions
Details:

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. Such behavior
now occurs under the transformations of other national symbols. In the
release notes that I have not found mention of such changes. Question: is
the bug? Sorry for my bad English.

Re: BUG #6230: strange changes in behavior of string functions

From
Tom Lane
Date:
"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