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@xxxxxxxxxx> 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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
