pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedproblems with changing the case of turkish characters
4+ messages / 2 participants
[nested] [flat]
* problems with changing the case of turkish characters
@ 2009-12-07 17:12 the6campbells <the6campbells@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: the6campbells @ 2009-12-07 17:12 UTC (permalink / raw)
To: 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şğüçö"
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problems with changing the case of turkish characters
@ 2009-12-07 17:28 Tom Lane <tgl@sss.pgh.pa.us>
parent: the6campbells <the6campbells@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2009-12-07 17:28 UTC (permalink / raw)
To: the6campbells <the6campbells@gmail.com>; +Cc: pgsql-sql
the6campbells <the6campbells@gmail.com> writes:
> 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'
Not sure why you'd be expecting an English locale to follow Turkish
case-changing rules.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problems with changing the case of turkish characters
@ 2009-12-07 21:20 the6campbells <the6campbells@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: the6campbells @ 2009-12-07 21:20 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
so where would I define something akin to what I can do in DB2 LUW where
collate using system means to sort by the codeset. ie. without english,
united states in LC_COLLATE.
USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM
On Mon, Dec 7, 2009 at 12:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> the6campbells <the6campbells@gmail.com> writes:
> > 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'
>
> Not sure why you'd be expecting an English locale to follow Turkish
> case-changing rules.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problems with changing the case of turkish characters
@ 2009-12-07 21:28 the6campbells <the6campbells@gmail.com>
parent: the6campbells <the6campbells@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: the6campbells @ 2009-12-07 21:28 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
to clarify. just trying to ensure I understand what PG 8.4 and 8.3 provide
where you may have data from alternate languages where ideally you'd like
them in the same table in the same database etc.
create table T ( c1 char( ...), c2 char (...) ... ) where c1 may contain
thai, c2 korean, c3 turkish etc names
vs
create table TKO (c1 char(...)), create table TTH (c1 char (...))
vs
different databases etc
On Mon, Dec 7, 2009 at 4:20 PM, the6campbells <the6campbells@gmail.com>wrote:
> so where would I define something akin to what I can do in DB2 LUW where
> collate using system means to sort by the codeset. ie. without english,
> united states in LC_COLLATE.
>
> USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM
>
>
>
>
> On Mon, Dec 7, 2009 at 12:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> the6campbells <the6campbells@gmail.com> writes:
>> > 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'
>>
>> Not sure why you'd be expecting an English locale to follow Turkish
>> case-changing rules.
>>
>> regards, tom lane
>>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2009-12-07 21:28 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-12-07 17:12 problems with changing the case of turkish characters the6campbells <the6campbells@gmail.com>
2009-12-07 17:28 ` Tom Lane <tgl@sss.pgh.pa.us>
2009-12-07 21:20 ` the6campbells <the6campbells@gmail.com>
2009-12-07 21:28 ` the6campbells <the6campbells@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox