Hi David, it's not possible to modify collation on a database cluster except in PostgreSQL 9.1. We're hoping to make it available to our users as soon as possible.
Regards, Peter van Hardenberg On Wed, Oct 5, 2011 at 5:46 AM, David Hall <[email protected]> wrote: > I am trying to find a way to get the Postgres database to understand > our Swedish umlauts correctly. I have found two [1] unanswered > questions on the topic of collation from other Scandinavians last year > but no solution. Is there a way to set collation on database level on > Postgres under Heroku? > > The specific problem I have is that ILIKE handles characters such as > "ä" and "Ä" as two different characters. > > > 1. "Heroku DB and sorting", > > http://groups.google.com/group/heroku/browse_frm/thread/fd206f57f41fb36d/414f415f3947c442 > "postgresql and sort order collation", > > http://groups.google.com/group/heroku/browse_thread/thread/2a270c4443e92b40/b7ca452a2a0fc583 > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
