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
