Re: BUG #5903: Turkish encoding problem

On Tue, Mar 1, 2011 at 1:59 AM, Sarp Akal <sarp@dms-tech.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =C2=A0 =C2=A0 =C2=A05903
> Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Sarp Akal
> Email address: =C2=A0 =C2=A0 =C2=A0sarp@dms-tech.com
> PostgreSQL version: 9.0.2
> Operating system: =C2=A0 Windows Server 2008 R2 x64
> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0Turkish 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('=C4=B0') =C2=A0--> Lowercase of turkish capital I-with dot =
returns
> exactly the same character.
>
> select upper('=C4=B1') =C2=A0--> Uppercase of turkish small i-without dot=
 returns
> exactly the same character.
>
> select lower('I') =C2=A0--> Lowercase of turkish capital I returns i wher=
e it
> should be i-without dot.
>
> select upper('i') =C2=A0--> 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.

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