Re: [GENERAL] Collate problem when using ORDER BY

2008-05-30 Thread Zdenek Kotala
David Harel napsal(a): Hi, I'm new here. I work on a site that uses postgres version 8.1.5 and database encoding ISO_8859_8. When I sort select requests using order by the "weight" of the characters seem to be really funny (but consistent). It seems to me that if I create a "phantom" converte

[GENERAL] Collate problem when using ORDER BY

2008-05-30 Thread David Harel
Hi, I'm new here. I work on a site that uses postgres version 8.1.5 and database encoding ISO_8859_8. When I sort select requests using order by the "weight" of the characters seem to be really funny (but consistent). It seems to me that if I create a "phantom" converted field such as: SELECT