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 implication in changing Postgresql to the C locale ...
other than
the order by and to_char handling ?
I'm running Postgresql as an ERP Database done by me and any mistakes I
do: I'm dead meat :P
If you have experience with this I welcome any reply ...
Other than that I will try in some other machine the
initdb --locale=C
just to be safe ...
Thanks again ,
Ruben Oliveira
-
Tom Lane wrote:
>Ruben Oliveira <ruben_dig@netcabo.pt> 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
>rather have had C locale).
>
> regards, tom lane
>
>
>