now for me ORDER BY LOWER(ASCII(column)), LOWER(column) (or some
variation there of) works, but is there a better workaround?
Thanks,
-Cody
Tom Lane wrote:
Cody Pisto <[EMAIL PROTECTED]> writes:
If this is potentially a problem in postgres somewhere, point me in the
general directio
rows)
And I bet oracle, firebird, sqlite, mssql, and everything else out there
that does utf8 would return it in the "right" order (I'm willing to test
that too if needed..)
If this is potentially a problem in postgres somewhere, point me in the
general direction and I&
Hi All,
I'm looking for any kind of a reason (and potential workarounds), be it
bug or otherwise, why the following two queries produce different
results under a database encoding of UTF8 and lc_collate of en_US.UTF-8:
SELECT x FROM (SELECT 'Something else' AS x UNION SELECT '-SOMETHING
ELSE
