[GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n - Mailing list pgsql-general

From Igor Korot
Subject [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n
Date
Msg-id CA+FnnTy2TK3A9KRUYt_Ox52hpcBS5g5zN=M_EBCNdPW6tUU2_g@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n
List 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.


pgsql-general by date:

Previous
From: marcelo
Date:
Subject: Re: [GENERAL] Schemas and serials
Next
From: John R Pierce
Date:
Subject: Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n