>> C locale and en_* locales give different ordering (at least under Linux).
>> The en_* ordering is case insensitive, and the C locale ordering is case
>> sensitive because it is simply comparing the ASCII codes.
>
> You could use lower/upper to get case insensitive ordering with C locale.
Okay, that's great, so I'm going to re-initialise my database cluster with
the C locale this week-end.
I'll report the results, for the record.
Thanks to everyone who replied!
Kind regards
Harry Mantheakis
London, UK