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.