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

Hi, John,

On Sun, Jul 30, 2017 at 4:53 PM, John R Pierce <pierce@hogranch.com> wrote:
> On 7/30/2017 1:43 PM, Igor Korot wrote:
>
> 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.

Looks like mine are as well:

draft=# \l+
                                                               List of databases
   Name    |  Owner   | Encoding | Collate | Ctype |   Access
privileges   |  Size   | Tablespace |                Description

-----------+----------+----------+---------+-------+-----------------------+---------+------------+--------------------------------------------
 draft     | postgres | UTF8     | C       | C     |
    | 11 MB   | pg_default |
 leagues   | postgres | UTF8     | C       | C     |
    | 5865 kB | pg_default |
 postgres  | postgres | UTF8     | C       | C     |
    | 5865 kB | pg_default | default administrative connection
database
 template0 | postgres | UTF8     | C       | C     | =c/postgres
   +| 5865 kB | pg_default | unmodifiable empty database
           |          |          |         |       |
postgres=CTc/postgres |         |            |
 template1 | postgres | UTF8     | C       | C     | =c/postgres
   +| 5865 kB | pg_default | default template for new databases
           |          |          |         |       |
postgres=CTc/postgres |         |            |
(5 rows)

I'm using the draft one.

Thank you.

>
>
> --
> john r pierce, recycling bits in santa cruz