Re: Choosing default collation/ctype

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>

To: Ron Johnson <ronljohnsonjr@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>

Date: 2026-05-03T21:17:04Z

Lists: pgsql-general

On Sun, 2026-05-03 at 17:05 -0400, Ron Johnson wrote:
> > Just trying to create a generic tool to use for people everywhere...
> 
> Then choose UTF8.

Right!  And I recommend "C" for the collation.
(The user can override the default in column definitions where necessary.)

Yours,
Laurenz Albe