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

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Invalid byte sequence for encoding UTF-8 0xc3\n
Date: 2017-07-30 20:19:18
Message-ID: CA+FnnTy2TK3A9KRUYt_Ox52hpcBS5g5zN=M_EBCNdPW6tUU2_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, ALL,
I am using a database for my project that I created inside SQLite3.
This database contains a table called "abc<ALT+225>" (it is "abc" +
symbol with the code 225 -
greek letter "beta or a German symbol for "ss").

All I did was to export that database into the text file and then imported this
file in the PostgreSQL.

Now, when trying to work with that table from libpq I am getting the
error above.

The program and database are on the same machine running OSX 10.8.

Trying to run the program under Xcode debugger I see that the table name becomes
"abc\xc3\x9f".

The error comes from the PQexecutePrepared() function.

Both the database and the table are created with default encoding.

What is the best way to handle this situation?

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2017-07-30 20:34:48 Re: Invalid byte sequence for encoding UTF-8 0xc3\n
Previous Message marcelo 2017-07-30 17:58:15 Re: Schemas and serials