Tom Lane wrote:
I now find that sorting is very different with that setting: It
appears, through trial and error, that all non-alphanumeric
characters are completely ignored by ORDER BY.
I doubt they are ignored completely, but they probably are ignored in
the first-order comparison.
The
In the course of creating a new PG 7.4.3 server, I chose UTF-8 as my
locale. I now find that sorting is very different with that setting: It
appears, through trial and error, that all non-alphanumeric characters
are completely ignored by ORDER BY. Thus, traditional tricks like
prefixing a name
On Tue, 20 Jul 2004, John Gunther wrote:
In the course of creating a new PG 7.4.3 server, I chose UTF-8 as my
locale. I now find that sorting is very different with that setting: It
As a note, UTF-8 is not a locale. My guess is that you are actually using
something like en_XX.UTF-8 (for some
John Gunther [EMAIL PROTECTED] writes:
In the course of creating a new PG 7.4.3 server, I chose UTF-8 as my
locale.
UTF-8 is a character set encoding, not a locale. I suspect you may
have chosen en_US or something like that as your locale.
I now find that sorting is very different with that