Blogmark
Speaking in Tongues: PostgreSQL and Character Encodings
via jbranchaud@gmail.com
https://thebuild.com/blog/2024/10/27/speaking-in-tongues-postgresql-and-character-encodings/
PostgreSQL
UTF-8
The character encoding decision is an easy one: Use UTF-8. Although one can argue endlessly over whether or not Unicode is the “perfect” way of encoding characters, we almost certainly will not get a better one in our lifetime, and it has become the de facto (and in many cases, such as JSON, the de jure) standard for text on modern systems.