Projects / pg_collkey


pg_collkey is a wrapper to use the collation functions of the ICU library with a PostgreSQL database server. Using this wrapper, you can specify the desired locale for sorting UTF-8 strings directly in the SQL query, rather than setting it during database installation. Default Unicode collation (DUCET) is supported. You can select whether punctuation should be a primary collation attribute or not. The level of comparison can be limited (in order to ignore accents, for example). Numeric sequences of strings can be recognized, so that 'test2' sorts before 'test10'. This library is dependent on ICU.


Recent releases

  •  02 Jun 2009 22:40

    Release Notes: This release adds support for PostgreSQL 8.3.

    •  26 Dec 2006 22:58

      Release Notes: This release adds support for PostgreSQL 8.2.

      •  09 Jun 2006 17:37

        No changes have been submitted for this release.


        Project Spotlight


        A Fluent OpenStack client API for Java.


        Project Spotlight

        TurnKey TWiki Appliance

        A TWiki appliance that is easy to use and lightweight.