On Tue, Jun 14, 2011 at 21:28, Michael Hepworth <michael.w.hepwo...@gmail.com> wrote: > Thanks for the response. I have created a database with lc_collate = > en_US.utf8. This doesn't seem to work. I does however allow me to sort my > non english names correctly. If I drop the database and recreate it with > lc_collate = C then my english names are ordered correctly but my > non-english names are sorted incorrectly.
I'm not sure you can use non english names in english locale. Instead, should you use another locale that covers all characters you use? I guess locales in libc on Ubuntu 10.4 is just broken or behaves undesirable as a feature. When I created english locale on Windows, it returnes expected results in both cases. Personally, I don't trust locale functions in libc on Linux platforms... -- Itagaki Takahiro -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
