Poul Møller Hansen <[EMAIL PROTECTED]> writes: > I'm wondering why the sort order on these two servers behaves differently. > The only difference I can see is that one is using a 32.bits Ubuntu and the > other is on 64bits versions of Ubuntu. > But why this difference ?
Try on both servers: show lc_collate Unfortunately you have to initdb to set the locale. You can't set it per database or change it once it's initialized. This one looks like en_US or something similar: > mydb=# select * from test order by felt1; > felt1 -------- > test1 > test_1 > test2 > test_2 > test3 > test_3 > (6 rows) > And this one looks like C: > mydb=# select * from test order by felt1; > felt1 -------- > test1 > test2 > test3 > test_1 > test_2 > test_3 > (6 rows) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
