Re: help

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Elizabeth George <g(dot)elizabeth(at)teles(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: help
Date: 2008-05-15 11:44:50
Message-ID: 20080515114450.GA25867@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

  • help at 2008-05-13 10:00:09 from Elizabeth George

Browse pgsql-general by date

  From Date Subject
Next Message Pavan Deolasee 2008-05-15 12:19:03 Re: Need for help!
Previous Message User Map 2008-05-15 11:34:26 calculating extent on basis of distance from a given point