Stange behavior of sort request - Mailing list pgsql-novice

From Simon GEORGES
Subject Stange behavior of sort request
Date
Msg-id 200908071339.49950.simon.georges@bull.net
Whole thread Raw
Responses [SPAM] Re: Stange behavior of sort request  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-novice
On a postgresql server (8.3.7) I send a request:
SELECT status FROM mytable ORDER BY status;
The result is :
3a
3b
3.
4.
5.
AB
...
With my encoding (UTF8) I expected to have 3. before 3a. Can anyone explain me
this strange behavior ?
Thank you.
Simon GEORGES

pgsql-novice by date:

Previous
From: Tim Greenwood
Date:
Subject: Checking my understanding of locales
Next
From: Michael Glaesemann
Date:
Subject: [SPAM] Re: Stange behavior of sort request