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

John et al,

On Mon, Jul 31, 2017 at 12:13 AM, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> 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.

My application has a different ways to connect to the database.
One way is thru the ODBC another is thru the native client library.

When trying to connect using ODBC (iODBC + PostgreSQL driver)
everything works correctly. There is no errors.
However, when trying to connect with libpq, I get the aforementioned error.

I tried to call:

setlocale( LC_ALL, "" );

before and after I get the connection as suggested by ODBC driver maintainer,
Hiroshi Inoue, but it didn't help.

Is there anything else I can try to fix the problem?

Thank you.

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