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

From David Wheeler
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id F47BE1C2-F567-11D8-990D-000A95972D84@kineticode.com
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
Responses Re: UTF-8 and LIKE vs =  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
On Aug 23, 2004, at 5:22 PM, Tatsuo Ishii wrote:

> Locales for multibyte encodings are often broken on many platforms. I
> see identical things with Japanese on Red Hat. This is one of the
> reason why I tell Japanese PostgreSQL users not to enable locale while
> initdb...

Yep, and exporting my data, deleting the data directory, running initdb
with --locale=C fixd the problem for me. Woot!

But given what you've said, Tatsuo, it makes me wonder if it's worth it
to use the system locale default when running initdb? Maybe it'd make
more sense for PostgreSQL to default to C unless someone specifies
another --locale?

Thanks for the help, everyone,

David

Attachment

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Next
From: Tim Allen
Date:
Subject: Re: UTF-8 and LIKE vs =