Friday, 27 September 2013

postgresql copy command delimiter non aphanumeric character

postgresql copy command delimiter non aphanumeric character

I am facing issue while copying a file which is delimited by §. The
database version is 9.1
File content are as below:
a§b§c 1§4§5
Copy command: copy test.test_ingestion (a,b,c) from 'b.csv' CSV HEADER
DELIMITER as E'§';
Error : invalid byte sequence for encoding "UTF8": 0xa7
As per my understanding § is a UTF-8 character and encoding of database is
set to UTF-8. So why is it failing to copy file delimited by §.

No comments:

Post a Comment