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

John,

On Sun, Jul 30, 2017 at 5:32 PM, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> Hi, John,
>
> On Sun, Jul 30, 2017 at 4:53 PM, John R Pierce <pierce(at)hogranch(dot)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.

And my application is compiled in UNICODE mode.

Now IIUC, in order to work correctly, the application and the database
should have
the same encoding. If I'm right, what is the way to get the encoding
of the database?

Thank you.

>
> Thank you.
>
>>
>>
>> --
>> john r pierce, recycling bits in santa cruz