-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Friday 08 June 2001 05:20, Rony Khoury wrote:
[collation sequencing problem regarding space interpretation in ORDER BY]
> I would like to know if this was solved in the new version? and if not
> someone should defenetly do something about it.
This is not a PostgreSQL issue, but a locale issue that was introduced by Red
Hat implementing 'correct' locale collation. PostgreSQL has to rely on the
system's C library for the string comparison/collation routines -- and those
routines are greatly changed by the locale setting.
Red Hat does not view this behavior as buggy.
Trond, I didn't know whether you are subscribed to the BUGS list or not, so I
am CC'ing you on this. The two collations:
example
new version:
BOU MOUSLEH
BOUSTANI
BOU YAZBEK
old version
BOU MOUSLEH
BOU YAZBECK
BOUSTANI
This appears to me to be wrong, Trond. Red Hat 7.1 out of the box
installation.
Rony, in the normal usage of these names, what would the correct collation be?
- --
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE7IPTi5kGGI8vV9eERAnesAKC0RxdvdPs3EcFR9MAkapPs5drwbQCfVQuY
xrUfcfOFjEzLdCPsLbV59PM=
=bsSL
-----END PGP SIGNATURE-----