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

On 2012-08-29, Bruce Momjian <bruce@momjian.us> wrote:

>>      Name     |  Owner   | Encoding  |   Collate   |    Ctype    |
>> Access privileges
>> --------------+----------+-----------+-------------+-------------+-----------------------
>>  clocale_utf8 | smarlowe | UTF8      | C           | en_US.UTF-8 |
>>
>>
>> SQL_ASCII is the encoding equivalent of C locale, but it also allows
>> multi-byte characters.
>
> Yes, but what sort ordering do you get in that case?
>

C ordering is by unicode code point number.

c=# values ('a'),('Z'),('€'),('z'),('¢'),('ä'),('Ā') order by 1;
 column1
---------
 Z
 a
 z
 ¢
 ä
 Ā
 €

--
⚂⚃ 100% natural