Re: PostgreSQL 9.1 / Collations / case insensitive german sort order - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL 9.1 / Collations / case insensitive german sort order
Date
Msg-id 13521.1308667214@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL 9.1 / Collations / case insensitive german sort order  (BGoebel <b.goebel@prisma-computer.de>)
List pgsql-general
BGoebel <b.goebel@prisma-computer.de> writes:
> I'm looking for a solution for managing case insensitive german charsets.
> I know this is an really "evergreen": Müller=MUELLER, like "Straße%", ...

> After studying the archive, i have not found a really simple solution.
> Using functions / functional indices is not what i'm looking for, I have to
> keep our software as compatible as possible with our old SQL database
> dialect. CITEXT is not usable with UTF-8 as I have read.

Dunno where you read that, but I don't believe it applies to the current
version of citext.

            regards, tom lane

pgsql-general by date:

Previous
From: "Leon Match"
Date:
Subject: Re: Call procedure from a Job, Test a Job in pgAdmin?
Next
From: Lincoln Yeoh
Date:
Subject: Re: PostgreSQL 8.4.8 bringing my website down every evening