Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n

what encodings are default on your system ?    `\l+` in psql should show the
encodings.

Is this "backslash + pipe + plus-sign"?

Trying it gives: "Invalid command".

\ + lower case L + plus sign, thats the psql metacommand to list all databases with extra info....

postgres=# \l+
                                                                       List of databases
      Name      |   Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   |  Size   | Tablespace |                Description                
----------------+-----------+----------+-------------+-------------+-----------------------+---------+------------+--------------------------------------------
 junk           | pierce    | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 6586 kB | pg_default |
 observers_test | observers | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 207 MB  | pg_default |
 pierce         | pierce    | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 6786 kB | pg_default |
 postgres       | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 6610 kB | pg_default | default administrative connection database
 scac           | scac      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 75 MB   | pg_default |
 scac_save      | scac      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 105 MB  | pg_default |
 smf            | smf       | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 34 MB   | pg_default |
 sympa          | sympa     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 6898 kB | pg_default |
 template0      | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +| 6457 kB | pg_default | unmodifiable empty database
                |           |          |             |             | postgres=CTc/postgres |         |            |
 template1      | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +| 6465 kB | pg_default | default template for new databases
                |           |          |             |             | postgres=CTc/postgres |         |            |
 tendenci       | tendenci  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 15 MB   | pg_default |
 test           | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |                       | 6634 kB | pg_default |
(12 rows)

for instance, all my databases are UTF8 on that server.

-- 
john r pierce, recycling bits in santa cruz