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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dmitry Ryabov" <dmitry-ryabov(at)mail(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6230: strange changes in behavior of string functions
Date: 2011-09-28 03:30:42
Message-ID: 28423.1317180642@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Dmitry Ryabov" <dmitry-ryabov(at)mail(dot)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 AYGTLAR') = '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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message depstein 2011-09-28 10:21:17 Re: Problems with ENUM type manipulation in 9.1
Previous Message Itagaki Takahiro 2011-09-28 03:06:22 Re: BUG #6227: No arguments for COPY OIDS and HEADER