On Sat, Apr 14, 2012 at 9:31 AM, Rural Hunter <ruralhunter@gmail.com> 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;