Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: GeoffreyDate: 2004-09-02 09:57:24
Subject: Re: Create Linux Script for PostgreSQL database backup
Previous:From: Kaolin FireDate: 2004-09-02 06:56:43
Subject: Re: Create Linux Script for PostgreSQL database backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group