Thread: help
Hi
I am trying to execute the query
SET CLIENT_ENCODING TO 'UNICODE';
copy (select 1 as F1) to E'c:\\test.out' csv QUOTE AS E'\xFE' FORCE QUOTE F1;
I got error like
ERROR: invalid byte sequence for encoding "UTF8": 0xfe
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".
Client encoding is Unicode and the server encoding is UTF8
pls help
Regards
Elizabeth K George
On Tue, May 13, 2008 at 03:30:09PM +0530, Elizabeth George wrote: > SET CLIENT_ENCODING TO 'UNICODE'; > copy (select 1 as F1) to E'c:\\test.out' csv QUOTE AS E'\xFE' FORCE > QUOTE F1; > > I got error like > > ERROR: invalid byte sequence for encoding "UTF8": 0xfe > 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". Right, because 0xfe is not a valid character in UTF-8. Pick something else. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.