Обсуждение: help

Поиск
Список
Период
Сортировка

help

От
"Elizabeth George"
Дата:

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

 

 

Re: help

От
Martijn van Oosterhout
Дата:
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.
Вложения