Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x

Thanks for replying.

Will there be any other difference like in terms of index size, etc?

Is there any link that I can refer that provides more details about the
differences?

On Fri 14 Sep, 2018, 5:27 PM Laurenz Albe, <laurenz(dot)albe(at)cybertec(dot)at> wrote:

> Debraj Manna wrote:
> > Can someone let me know what is the difference we are expected to
> observe if we set
> > Collate & Ctype to C as against en_US.UTF-8 with encoding set to UTF8
> in both the cases ?
>
> For one, the ordering will be substantially different.
>
> Compare the result of these two queries:
>
> SELECT chr(i) FROM generate_series(1, 50000) i ORDER BY chr(i) COLLATE "C";
> SELECT chr(i) FROM generate_series(1, 50000) i ORDER BY chr(i) COLLATE
> "en_US.utf8";
>
> Yours,
> Laurenz Albe
>
>