Re: Unicode + LC_COLLATE - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Unicode + LC_COLLATE
Date
Msg-id 200404231206.12873.peter_e@gmx.net
Whole thread Raw
In response to Re: Unicode + LC_COLLATE  ("Priem, Alexander" <ap@cict.nl>)
List pgsql-general
Am Donnerstag, 22. April 2004 16:37 schrieb Priem, Alexander:
> But if you use anything other than C, you can't use indexes in
> Like-clauses, right?

No, see <http://www.postgresql.org/docs/7.4/static/indexes-opclass.html>.

> Would lc-collate=C be bad in combination with UNICODE encoding? What
> lc-collate setting would you recommend for UNICODE encoding which will
> provide good sorting for all (most) common languages? (dutch, english,
> french, german)

That is currently not supported at all by PostgreSQL.  You would need to use a
single-byte encoding.


pgsql-general by date:

Previous
From: Dragan Matic
Date:
Subject: Case insensitive search
Next
From: mike
Date:
Subject: Question about inserts