Re: BUG #5903: Turkish encoding problem

When we run an application on the same machine & OS, application's lower and upper functions results are correct but PostgreSQL does not behave similar.

-----Original Message-----
From: Robert Haas [mailto:robertmhaas(at)gmail(dot)com]
Sent: Thursday, March 03, 2011 8:32 PM
To: DMS Tech, Sarp
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #5903: Turkish encoding problem

On Tue, Mar 1, 2011 at 1:59 AM, Sarp Akal <sarp(at)dms-tech(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5903
> Logged by:          Sarp Akal
> Email address:      sarp(at)dms-tech(dot)com
> PostgreSQL version: 9.0.2
> Operating system:   Windows Server 2008 R2 x64
> Description:        Turkish encoding problem
> Details:
>
> The server is setup for UTF8 encoding and collation and character type are
> Turkish_Turkey.1254
>
> The following code fails:
>
> select lower('İ')  --> Lowercase of turkish capital I-with dot returns
> exactly the same character.
>
> select upper('ı')  --> Uppercase of turkish small i-without dot returns
> exactly the same character.
>
> select lower('I')  --> Lowercase of turkish capital I returns i where it
> should be i-without dot.
>
> select upper('i')  --> Uppercase of turkish small returns I where it should
> be I-with dot.

I might be wrong about this, but I think this behavior is determined
by the operating system behavior of the locale you've selected, and we
just believe whatever the OS says.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company