Search Postgresql Archives

help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux