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.albe@xxxxxxxxxxx> 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
