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 8.4 Yesterday the newest PostgreSQL 8.4 has been released. Great, but...
4. PostgreSQL Wishlist PostgreSQL is a great database, in my opinion much...
5. Checking PostgreSQL Database Creation Date Some time ago we had a problem: on testing there...
6. PostgreSQL FOUND Problem FOUND is a global variable that exists in the plpgsql...