help

From: "Elizabeth George" <g(dot)elizabeth(at)teles(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Elizabeth George" <g(dot)elizabeth(at)teles(dot)com>
Subject: help
Date: 2008-05-13 10:00:09
Message-ID: 4E3524B7F7154D4D93ABCF5E2471224FC544@dc-india.telesindia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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


Responses

  • Re: help at 2008-05-15 11:44:50 from Martijn van Oosterhout

Browse pgsql-general by date

  From Date Subject
Next Message Elizabeth George 2008-05-13 10:23:45 help
Previous Message Semi Noob 2008-05-13 09:13:46 Need for help!