How to use different lc_collate nad lc_ctype settings.

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: How to use different lc_collate nad lc_ctype settings.
Date: 2006-12-03 09:40:05
Message-ID: eku63g$fin$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My 8.1 cluster lc_collate and lc_ctype are
Estonian_Estonia.1257. Database encoding is UTF8.

Some columns in some tables contain data in Russian,Finnish, German and
Latvian languages.

I need to force server to perform sorting and case insensitive search for
those columns using column language.

How this can be performed ?

Andrus

Browse pgsql-general by date

  From Date Subject
Next Message vivek 2006-12-03 10:53:30 Re: select query not using index
Previous Message Russell Smith 2006-12-03 03:20:13 Re: fatal error on 8.1 server