BGoebel <b(dot)goebel(at)prisma-computer(dot)de> writes:
> I'm looking for a solution for managing case insensitive german charsets.
> I know this is an really "evergreen": Mller=MUELLER, like "Strae%", ...
> 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