help - Mailing list pgsql-general

From Elizabeth George
Subject help
Date
Msg-id 4E3524B7F7154D4D93ABCF5E2471224FC545@dc-india.telesindia.com
Whole thread Raw
List 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

 

 

 

pgsql-general by date:

Previous
From: Michal Szymanski
Date:
Subject: Problem with transaction isolation level
Next
From: Kev
Date:
Subject: Re: Upgreade 8.3.0 to 8.3.1 on windows: insufficient privileges to install system service