Thread: PostgreSQL 9.1 / Collations / case insensitive german sort order

Hi,

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. ILIKE does not use
indices.

I found a patch (mchar) which looks promising.
http://postgresql.1045698.n5.nabble.com/Case-Insensitve-Text-Comparison-td1983179.html

The collation support with PostgreSQL 9.1 will not solve this problem (or
did I miss something?).

Does anybody has an advice for a PostgreSQL newbie?

Any help greatly welcome.


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-9-1-Collations-case-insensitive-german-sort-order-tp4510232p4510232.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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