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.