Re: Help understanding locale

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Help understanding locale
Date: 2004-09-02 07:56:38
Message-ID: 200409020956.38901.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am Mittwoch, 1. September 2004 23:03 schrieb Chris Hoover:
> Would you please be so kind to provide a bit more explanation? How will
> the sort differ?

C sorts by byte value, which ends up being AB...Zab...z. en_US sorts using
"dictionary order", which means aAbB...zZ, accented characters appear at
their correct place, whitespace is ignored. The latter in principle applies
to all other language-specific locales as well, except that the particular
relative order of the letters may be different.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Geoffrey 2004-09-02 09:57:24 Re: Create Linux Script for PostgreSQL database backup
Previous Message Kaolin Fire 2004-09-02 06:56:43 Re: Create Linux Script for PostgreSQL database backup