problems with changing the case of turkish characters

From: the6campbells <the6campbells(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: problems with changing the case of turkish characters
Date: 2009-12-07 17:12:51
Message-ID: 22431f1b0912070912p10c3191flaab6cee97e5ab63f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Just want to clarify if there is something I've overlooked or if this is a
known issue in PG 8.4 and 8.3

CREATE DATABASE test
WITH OWNER = postgres
ENCODING = 'UTF8'
LC_COLLATE = 'English, United States, UTF-8'
LC_CTYPE = 'English, United States, UTF-8'

select ('İsteği') from tversion
"İsteği" was expecting "isteği"

select upper('iışğüçö') from tversion
"IıŞĞÜÇÖ"

select lower ('İIŞĞÜÇÖ') from tversion
"İişğüçö"

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2009-12-07 17:28:08 Re: problems with changing the case of turkish characters
Previous Message tv 2009-12-07 13:53:19 Re: Query Performance