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

Поиск
Список
Период
Сортировка
От Igor Korot
Тема [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n
Дата
Msg-id CA+FnnTy2TK3A9KRUYt_Ox52hpcBS5g5zN=M_EBCNdPW6tUU2_g@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: marcelo
Дата:
Сообщение: Re: [GENERAL] Schemas and serials
Следующее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n