Encoding/collation question

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Encoding/collation question
Date: 2019-12-11 19:16:05
Message-ID: alpine.LNX.2.20.1912111112510.10822@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My older databases have LATIN1 encoding and C collation; the newer ones have
UTF8 encoding and en_US.UTF-8 collation. A web search taught me that I can
change each old database by dumping it and restoring it with the desired
encoding and collation types. My question is whether the older types make
any difference in a single-user environment.

Regards,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-12-11 19:20:10 Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?
Previous Message Erwin Brandstetter 2019-12-11 18:07:09 Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?