Search Postgresql Archives

Re: Error When Trying to Use Npgsql to COPY into a PostgreSQL Database

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

 



Adrian, I actually figured it out. It was a really silly mistake - basically
I was testing something earlier and edited my ODBC connection string. I was
actually connecting to the wrong database and it was an empty database, so
ODBCDataReader was trying to pull data from an empty table. Anyways, this is
fixed. However, I have a new problem.

I occasionally get an ERROR: 22021: invalid byte sequence for encoding
"UTF8": 0x92 when using the COPY query and this stops the whole process. It
occurs here in my code...

var raw = Encoding.UTF8.GetBytes(string.Concat(dataEntry, "\n"));
copy.CopyStream.Write(raw, 0, raw.Length);

dataEntry is a string. I have tried a few things to try and remove any
non-UTF8 characters from the string, but it has failed so far. Any ideas?



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Error-When-Trying-to-Use-Npgsql-to-COPY-into-a-PostgreSQL-Database-tp5808954p5808982.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.



[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