BUG #5903: Turkish encoding problem - Mailing list pgsql-bugs

From Sarp Akal
Subject BUG #5903: Turkish encoding problem
Date
Msg-id 201103010659.p216xlY1096718@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5903: Turkish encoding problem  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5903
Logged by:          Sarp Akal
Email address:      sarp@dms-tech.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.

pgsql-bugs by date:

Previous
From: Nacho Mezzadra
Date:
Subject: Re: BUG #5896: When server cannot be started, first it says that it couldn't be started and then Server Started
Next
From: Ingmar Brouns
Date:
Subject: Re: BUG #5902: pl/pgsql plans are not invalidated on discard all