Re: help - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: help
Date
Msg-id 20080515114450.GA25867@svana.org
Whole thread Raw
In response to help  ("Elizabeth George" <g.elizabeth@teles.com>)
List pgsql-general
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.

Attachment

pgsql-general by date:

Previous
From: User Map
Date:
Subject: calculating extent on basis of distance from a given point
Next
From: "Pavan Deolasee"
Date:
Subject: Re: Need for help!