Pete_Halsted
New member
Joined: 20/01/2010 11:50:47
Messages: 1
Offline
|
We are working on migrating from MS-SQL to Postgres Advanced. We are using the Migration studio to attempt to convert the Schema and data. Schema is coming over but we have several tables that are giving us encoding errors (see below). We can't figure out the right combination of setting to resolve the issue.
The other issue we have is with the delimiter character we have a few tables that contain | characters. In fact all 127 of the Basic ASC chart are represented in our data, and my first attempt at using extended ascii characters above 127 didn't seem to work either. Any suggestions on what character to use?
Thanks
Pete Halsted
JK Harris
636-432-9339
First error:
Loading Table: prospect ...
Error Loading Data into Table: outboundcustomer: ERROR: invalid byte sequence for encoding "UTF8": 0xd13f
Hint: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
Where: COPY outboundcustomer, line 865
Then when it completes all tables in first pass we get:
Trying to reload table: outboundcustomer through bulk inserts with a batch size of 1000
ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252", Skipping Batch
|