Hi, I am running 8.2.1 on my Mac OS X and my X86 Fedora Laptop...
I just noticed that on my mac: levan=# select 'A' < 'a' ; ?column? ---------- t (1 row) and on the linux box: levan=# select 'A' < 'a' ; ?column? ---------- f (1 row) The locale function on the mac has everything set to "C" and on the linux box it is all "en_US.UTF-8". Is there a simple way to get the collating sequences to be the same on both boxen? If I do an "order by <text>" on the mac then if the referenced field starts with a lower case letter then it will appear after all of the fields that start with an upper case letter.... Thanks, Jerry ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
