I am trying to load data into a rather simple table: CREATE TABLE "public"."files" ( "id" SERIAL, "idchar" CHAR(32) NOT NULL, "content" BYTEA, CONSTRAINT "files_pkey" PRIMARY KEY("id") ) WITHOUT OIDS;
with this command: copy files (idchar, content) from '/data/1.dat' delimiter '|'; The database encoding is UTF-8. Here is an example of the data file content: 0C2CCE6941194369B020000B616F1301|\xFF\xD8\xFF\xE0\x00\x10\x4A\x46\x49\x46\x00\x01 And I get this error: ERROR: invalid byte sequence for encoding "UTF8": 0xff The command set client_encoding = 'SQL_ASCII'; Does not helps at all, the result is the same error message. How can I turn off that annoying codepage checking during COPY FROM ? Isn't it a bug ? In my humble opinion, tt definitely should not check the encoding for columns of type bytea. Cheers, R.G. Disclaimer: http://www.aps-holding.com/disclaimer.html