On 06/24/2014 01:37 PM, Altec103 wrote:
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?
A more on point example: http://npgsql.projects.pgfoundry.org/docs/manual/UserManual.html Fast bulk data copy into a table The second example show how to deal with different client/server encodings.
-- 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.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
