I have batch files with entries such as
INSERT INTO country VALUES (248,'ALA','AX','Åland Islands');
INSERT INTO country VALUES (384,'CIV','CI','Côte d\'Ivoire');
I tried to execute them using "pgsql \i filename.sql"
Unfortunately, I keep getting an error message:
"ERROR: invalid byte sequence for encoding "UNICODE": 0xc56c"
How can that be possible?
My database is set to encoding "UNICODE" and so are the batchfiles.
Why does that not work?
Thanks
Matt