public inbox for pgsql-general@postgresql.org  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron Johnson <ronljohnsonjr@gmail.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Choosing default collation/ctype
Date: Sun, 03 May 2026 23:17:04 +0200
Message-ID: <63e4b5165442ada9f187a0e14bbfe04795088bcd.camel@cybertec.at> (raw)
In-Reply-To: <CANzqJaABDxgMYHOWVKFgZC-B1-JznyyghCPHVbwUR9datT-MWg@mail.gmail.com>
References: <CA+FnnTyJDvLijfizguNahiRO1LMHR4t9=_9-aO8P18cDZ6RRGA@mail.gmail.com>
	<CANzqJaB=zwoYT_rBwUX8q4VyqQBGWyjvAiW=UAJZ0+eh7HU0Zg@mail.gmail.com>
	<CA+FnnTwpjzm+QNTtyx=J8LGmbS90ceVWaysfzbo-OxNi5Fq2kA@mail.gmail.com>
	<CANzqJaABDxgMYHOWVKFgZC-B1-JznyyghCPHVbwUR9datT-MWg@mail.gmail.com>

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






reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: laurenz.albe@cybertec.at, ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
  Subject: Re: Choosing default collation/ctype
  In-Reply-To: <63e4b5165442ada9f187a0e14bbfe04795088bcd.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox