Re: invalid byte sequence for encoding "UTF8": 0xf481 - how could this happen?

[Rural Hunter <ruralhunter@xxxxxxxxx>]

still doesn't work.
db=# set client_encoding='SQL_ASCII' ;
SET
db=# select to_tsvector(content) from tmp_article;
ERROR:  invalid byte sequence for encoding "UTF8": 0xf481


于 2012/4/15 1:38, raghu ram 写道:

On Sat, Apr 14, 2012 at 9:31 AM, Rural Hunter <ruralhunter@xxxxxxxxx> wrote:

doesn't work either.

db=# show client_encoding;
 client_encoding
-----------------
 UTF8
(1 row)

db=# set client_encoding='LATIN1';
SET
db=# show client_encoding;
 client_encoding
-----------------
 LATIN1
(1 row)

db=# select to_tsvector(content) from tmp_article;

ERROR:  invalid byte sequence for encoding "UTF8": 0xf481

Try to set client_encoding='SQL_ASCII' 

and then execute 

select to_tsvector(content) from tmp_article;

--

Thanks & Regards,

Raghu Ram

EnterpriseDB: http://www.enterprisedb.com