At Thu, 6 Jan 2005 16:16:05 +1100 (EST), Stuart Guthrie wrote: > So Debian seems to be initialising postgres dbs with the first of these > collate sequences meaning that whatever 'C' is seems to return > case-sensitive search results. > > Mandrake's standard RPM implements postgres with en_US collation sequences > which means it sorts AaBbCcDd which is what I'd be hoping for.
Run "dpkg-reconfigure --priority=low postgresql". One of the questions is what encoding you want to use by default (although since you obviously *rely* on the encoding, then I'd suggest mentioning it explicitly in the CREATE DATABASE statement anyway). -- - Gus -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html