Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux