Re: UTF-8 and LIKE vs = - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id 20040825.074145.71085527.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
> David Wheeler wrote:
> > That's not the trouble so much as that the locales can be badly
>
> If we always followed the principle "X could be broken, so let's not use
> X", then we would never get anything done.  Instead, "X is broken, so
> fix it".

It's not a fair example IMO. We have many counter examples in our
source code itself which are trying to workaround verndors "minor"
bugs. Probably the point is X is important for almost everyone, while
the locale collation is not so for most of Linux uses (and thus for
vendors).  Unfortunately our voices are so small and does not reach to
verndors...

> > broken, and that they're useless for multilingual use.
>
> I don't agree with that, but perhaps we differ in our interpretation of
> "multilingual use".  If you have special requirements, you can always
> turn the locales off.

And they are forced to run initdb...
--
Tatsuo Ishii

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Deadlocks caused by referential integrity checks
Next
From: Carlos Moreno
Date:
Subject: Re: Is this legal SQL? Is it a good practice?