help

From: "Elizabeth George" <g(dot)elizabeth(at)teles(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: help
Date: 2008-05-13 10:23:45
Message-ID: 4E3524B7F7154D4D93ABCF5E2471224FC545@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



Browse pgsql-general by date

  From Date Subject
Next Message Lionel 2008-05-13 11:02:00 Upgreade 8.3.0 to 8.3.1 on windows: insufficient privileges to install system service
Previous Message Elizabeth George 2008-05-13 10:00:09 help