Re: Locale-based identifier conversion and Turkish - Mailing list pgsql-hackers

From Devrim GUNDUZ
Subject Re: Locale-based identifier conversion and Turkish
Date
Msg-id Pine.LNX.4.44.0312152230570.15386-100000@emo.org.tr
Whole thread Raw
In response to Re: Locale-based identifier conversion and Turkish  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Mon, 15 Dec 2003, Tom Lane wrote:

> > As you can see "I" in "VOID" gets converted to i-dotless in conformance
> > to tr_TR Locale conversion rules, which is not an expected behaviour for
> > Turkish users who set their locale to tr_TR.
> 
> Why is it not expected behavior?  The SQL99 spec has not changed from
> what it said when we discussed this last year: case conversion of
> identifiers is *not* to be done in plain-ASCII rules.  Admittedly it
> says "unicode" and not "locale", but you'd have the same problem if we
>  had a full unicode implementation, no?

I'm pretty sure that Nicolai will explain things better; so it's better to 
wait for his e-mail.

If PostgreSQL had a full unicode implementation, as you've said: Yes, we 
would experience the same problems.

We also have a problem while sorting result in a SELECT query, which seems 
a similar issue as this one. In Turkish, i-dotless comes just before i in 
alphabet; but PostgreSQL places i-dotless 'after' i, which is a false 
result. Nicolai will also report this bug, and explain why/how it happens.

> My feeling is that the best answer is to use lower case names to
> reference identifiers in the initdb code.  This is not a real pleasant
> prospect, but I can't see giving up on spec-compatible case folding ...

This is what we've also thought in here.

Regards,
- -- 
Devrim GUNDUZ
devrim@gunduz.org                devrim.gunduz@linux.org.tr         http://www.TDMSoft.com
http://www.gunduz.org

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/3iwVtl86P3SPfQ4RAl1VAJ9vmbEwq2pbAoPWY+lmVKSLhhabJQCgrzN9
zIRLFXS5WxjnZKbaO9XviA4=
=SDYx
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-hackers-win32] [PATCHES] fork/exec patch
Next
From: Bruce Momjian
Date:
Subject: 7.4.1 release notes