PostgreSQL Collation – 8.4

In the last PostgreSQL version (8.4) there is a small change for the problem with collation. There can be set collation per database, not per cluster, so using only one PostgreSQL instance it is possible to have many databases with different language settings.

What I keep on waiting for is to have to possibility of defining a collation for each column not only for each database but I hope it will be added in next versions.

What the collation is and how it was in the previous PostgreSQL version is described here:

• http://www.simononsoftware.com/postgresql-collation/
• http://www.simononsoftware.com/postgresql-collation-2/

Bookmark It

Related posts:

1. PostgreSQL Collation – part 1 PostgreSQL is (IMHO) much better than MySQL but unfortunately it ...
2. PostgreSQL Collation – part 2 Due to many questions about the PostgreSQL collation that were...
3. PostgreSQL 9.1 Best Features PostgreSQL 9.1 is almost out. That’s great. There are many...
4. PostgreSQL 8.4 Yesterday the newest PostgreSQL 8.4 has been released. Great, but...
5. Reviewing PostgreSQL 9.0 High Performance I’ve already started writing a review of the second new...
6. What Is The Real PostgreSQL Triggers Ordering Introduction During the last database training that I led, I...