On Fri, 16 Dec 2005 11:59:48 -0600, Csaba Nagy <nagy@xxxxxxxxxxxxxx> wrote:
On Fri, 2005-12-16 at 18:52, Tom Lane wrote:
Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes:
> ... So "tyty" and "tty" could be arguably both taken as double "ty",
> except that the official form is "tty"... but from a pronunciation
point
> of view they ARE equivalent in hungarian.
That's fair enough, but the question is should they be taken as
equivalent for string-comparison purposes? (English has plenty of
cases where different letter combinations sound alike, but we don't
consider them equal because of that. That may not be a good analogy
though. Also, if there are cases in other locales where strcoll
considers non-identical strings equal, the reasoning for it might be
quite different.)
Well, I'm not an expert on this one. In any case, hungarian has
phonetical writing as opposed to the etymological writing English has.
So in hungarian there is a 1 to 1 mapping between the sounds and the
signs used to depict them... so pronunciation is somewhat more relevant
in sorting I guess. But I'm not a linguist so I won't know for sure.
Trouble is, you can never guarantee that you're dealing with actual words.
What of you're comparing someone's password that happens to contain
combination of letters that act in this way?
Cheers,
Csaba.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Russ
