Thread: Stange behavior of sort request

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

On Aug 7, 2009, at 7:39 , Simon GEORGES wrote:

> With my encoding (UTF8) I expected to have 3. before 3a. Can anyone
> explain me
> this strange behavior ?

As I understand it, sort order is determined by your locale rather
than the encoding.

Michael Glaesemann
grzm seespotcode net