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