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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL 9.1 / Collations / case insensitive german sort order
Дата
Msg-id 13521.1308667214@sss.pgh.pa.us
обсуждение
Ответ на PostgreSQL 9.1 / Collations / case insensitive german sort order  (BGoebel <b.goebel@prisma-computer.de>)
Список 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 по дате отправления: