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:robertmh...@gmail.com] Sent: Thursday, March 03, 2011 8:32 PM To: DMS Tech, Sarp Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5903: Turkish encoding problem On Tue, Mar 1, 2011 at 1:59 AM, Sarp Akal <s...@dms-tech.com> wrote: > > The following bug has been logged online: > > Bug reference: 5903 > Logged by: Sarp Akal > Email address: s...@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. 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
