BGoebel <b.goebel@xxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general