http://forums.enterprisedb.com/posts/list/11.page JForum - http://www.jforum.net
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
]]> http://forums.enterprisedb.com/posts/preList/2131/7960.page http://forums.enterprisedb.com/posts/preList/2131/7960.page GMT