Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL)

On Wed, 2012-08-29 at 10:31 -0700, Aleksey Tsalolikhin wrote:
> What is the difference between C and en_US.UTF8, please?

There are many differences, but here is a simple one:

$ (echo a; echo A; echo b; echo B) | LC_ALL=C sort
A
B
a
b
$ (echo a; echo A; echo b; echo B) | LC_ALL=en_US.utf8 sort
a
A
b
B