On Tue, Jun 14, 2011 at 21:28, Michael Hepworth
<michael.w.hepworth@gmail.com> wrote:
> Thanks for the response.=C2=A0 I have created a database with lc_collate =
=3D
> en_US.utf8.=C2=A0 This doesn't seem to work.=C2=A0 I does however allow m=
e to sort my
> non english names correctly.=C2=A0 If I drop the database and recreate it=
with
> lc_collate =3D 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...
--=20
Itagaki Takahiro