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