Re: Updating default PostgreSQL server encoding from SQL_ASCII to UTF8

[Luis Falcon <falcon%gnuhealth.org@localhost>]

El Tue, 8 Sep 2026 21:22:43 +0000 (UTC)
RVP <rvp%SDF.ORG@localhost> escribió:
> 
> This works if you use LC_CTYPE instead: `export LC_CTYPE=C.UTF-8'

Thank you!! Indeed, setting only LC_CTYPE does the trick, and everything
becomes much easier, starting with the documentation :)

 psql -U pgsql -l
                                              List of databases
   Name    | Owner | Encoding | Locale Provider | Collate |  Ctype  | Locale | ICU Rules | Access privileges
-----------+-------+----------+-----------------+---------+---------+--------+-----------+-------------------
 postgres  | pgsql | UTF8     | libc            | C       | C.UTF-8 |        |           |
 template0 | pgsql | UTF8     | libc            | C       | C.UTF-8 |        |           | =c/pgsql         +
           |       |          |                 |         |         |        |           | pgsql=CTc/pgsql
 template1 | pgsql | UTF8     | libc            | C       | C.UTF-8 |        |           | =c/pgsql         +
           |       |          |                 |         |         |        |           | pgsql=CTc/pgsql
(3 rows)

Best
Luis