Invalid Byte Sequence
Posted: Fri 29 Feb 2008 12:45
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.
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.