From: tjk@tksoft.com <tjk@tksoft.com>
To: eroloz@bilgi.edu.tr
Cc: pgsql-sql@postgresql.org
Subject: Re: Localization or an other solution
Date: Wed, 12 Apr 2000 16:31:19 -0700 (PDT)
Message-ID: <200004122331.QAA22734@uno.tksoft.com> (raw)
In-Reply-To: <38F4F721.8F78C4C5@bilgi.edu.tr>
Followup on my own message.
I just paused for a second and realized you couldn't
do straight sorting, since then all text would be handled
that way.
It seems the only way external functions could be used
to help you out would be to write a turkishhash
function which assigns a value to all strings, based on
their alphabetic order, in Turkish. Then you could
sort the results of a query with something like this:
select username from testtable order by turkishhash(username);
You would get into trouble with long strings and large
tables, as they received the same hash value. The
solution might be better than nothing, though.
Troy
>
> Hi,
> As everybody knows, or at least guess, the Turkish-specific characters
> is ordered incorrectly unless you don't have localization support. (For
> example there is a letter like 's' but has a dot under it; this letter
> must come after 's'; without localization support this and other
> non-English ones come after 'z' )
> According to the manual, localization causes the loose of performance.
> Beside, I scare to use localization which is not familiar to me. Because
> of these, I try to find an other solution. The one that I think on is
> - to use a seperate field for each of the fields that I want to order;
> - to put a correctly-sortable version of the data in the related field
> - and to use this extra fields for sorting purposes.
> Example:
> Original data: 'þimþek'
> In extra field: 'szzimszzek'
> Finally, my question is:
> In a table which has 100.000 or more records, which one will be more
> faster? Localization or this one.
> Thanks in advance
> Erol Oz
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tjk@tksoft.com, eroloz@bilgi.edu.tr
Subject: Re: Localization or an other solution
In-Reply-To: <200004122331.QAA22734@uno.tksoft.com>
References: <38F4F721.8F78C4C5@bilgi.edu.tr> <200004122331.QAA22734@uno.tksoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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