On 2012-08-29, Bruce Momjian <bruce(at)momjian(dot)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