pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
unexpected ORDER BY 2+ messages / 2 participants [nested] [flat]
* unexpected ORDER BY @ 2010-11-09 16:00 Andreas <maps.on@gmx.net> 0 siblings, 1 reply; 2+ messages in thread From: Andreas @ 2010-11-09 16:00 UTC (permalink / raw) To: pgsql-sql Hi, I've got an PG 8.4 on a opensuse box running. The DB is unicode german. There is a text column I'd like to order by but as far as I see PG ignores special chars and uses only characters and numbers. E.g. I get : S&T C... S&T E... STP <-- ??? STP A <-- ??? S&T P... S&T R... Can I modify the SELECT or even better switch a global setting that PG uses all chars to sort? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: unexpected ORDER BY @ 2010-11-09 16:10 Tom Lane <tgl@sss.pgh.pa.us> parent: Andreas <maps.on@gmx.net> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2010-11-09 16:10 UTC (permalink / raw) To: Andreas <maps.on@gmx.net>; +Cc: pgsql-sql Andreas <maps.on@gmx.net> writes: > I've got an PG 8.4 on a opensuse box running. > The DB is unicode german. > There is a text column I'd like to order by but as far as I see PG > ignores special chars and uses only characters and numbers. This is driven by the locale you're using, specifically the LC_COLLATE setting. If you want "plain ASCII" sort order, you need to switch to C locale. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-11-09 16:10 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-11-09 16:00 unexpected ORDER BY Andreas <maps.on@gmx.net> 2010-11-09 16:10 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox