Hi guys,
I am not sure if this is the right forum but here goes ...
I am moving data from SQL Server to PostgreSQL. The table in SQL Server is slightly different in structure to the one in PostgreSQL. To do the move I perform the following:
1. Fill Dataset1 with the contents of the SQL Server table.
2. Move the data from each field in the table in Dataset1 to the corresponding field in the table in Dataset2.
3. Use the Update method of Dataset2 to populate the PostreSQL database.
The operation runs smoothly at first but then some records are causing this error message: invalid byte sequence for encoding "UTF8": 0x00. The SQL Server database uses the SQL_Latin1_General_CP1_CI_AS collation. PostgreSQL uses UTF8 encoding. I'm guessing this could be the root of my problem.
How do I get past this error?
Thanks.
Invalid Byte Sequence
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
RE: Invalid Byte Sequence
OK, after a couple hours of character hunting (it's a large table) I was finally able to isolate the field. A few minutes later, I was able to isolate the offending 0x00 character. Peace has returned to the village
Thanks for the input ...
Thanks for the input ...
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24