Invalid byte sequence for Utf-8 when "insert into.."

[codymanix]

I got a message sounding like that. My Postgres server runs Utf8 and Iam using WindowsXP. The message appears when I try to insert string data which contains non-ascii characters like ä.
Iam using the Npgsql .NET provider to access the database. Since .NET internally always uses UTF16 I do not see the problem.

 

[Marin007]

You have to use ENCODING=UNICODE int hte connection string. I suppose you are using Npgsql. This oprion does not exist in the PostgreSQL documentation, you can only find it in the documentation of NpgsqlConnecetion constructor.