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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html