Re: Mixed Locales and Upgrading

[Don Seiler <don@xxxxxxxxx>]

On Tue, Mar 17, 2020 at 8:06 AM Don Seiler <don@xxxxxxxxx> wrote:

On Mon, Mar 16, 2020 at 10:28 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Well, in principle you could likewise manually update pg_database's
datcollate and datctype columns to say "en_US.utf8".  However, there's
a much bigger problem here --- what steps if any did this cowboy take
to ensure that the data inside the database was valid UTF8?

Is there a way to programmatically check for data that might be a problem now?

--

Don Seiler
www.seiler.us