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

From Joel
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id 20040825105908.AA1D.REES@ddcom.co.jp
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Peter Eisentraut wrote
> 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".

You want to talk my employer into giving me a month (full time) to build
some foundation open source tools, with the understanding that when
that's done maybe we'll know enough to actually be able to pin down a
schedule for fixing this one?

> > 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".

Yes. There is a huge difference between incidental use of CJKV encodings
in a mostly Latin-based language database and using incidental Latin
characters in a mostly CJKV database.

> If you have special requirements, you can always
> turn the locales off.

Wish it were that simple, but that's where we apparently have to start,
for now.

--
Joel <rees@ddcom.co.jp>


pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Next
From: Joel
Date:
Subject: Re: UTF-8 and LIKE vs =