Thanks for the quick reply :)
I missed the localization part of the manual , shame on me !!
http://www.postgresql.org/docs/current/static/charset.html
LC_COLLATE String sort order
I did:
set|grep LC
and because I am portuguese it returns pt_PT
just a quick question if you please :
is there any impl
On Tue, 15 Feb 2005, Ruben Oliveira wrote:
> Hello everybody !
>
> I have this order by :
> select lalala from tablex order by field_y;
> where field_y is a text column.
>
> that returns something like :
> 2.1004.11
> 21.00.461
> 2.1006.21
>
> in PostgreSQL 7.3.2 in Linux Mandrake 9.1
>
> but in
Ruben Oliveira <[EMAIL PROTECTED]> writes:
> Can anybody tell me if there is something I can do in the Linux config
> to have the same order by result ??
Sort order is determined by locale, not encoding. You did the Linux
initdb in the wrong locale (possibly something like en_US where you'd
rath
