On Sat, Apr 14, 2012 at 9:31 AM, Rural Hunter <ruralhunter(at)gmail(dot)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;
--
Thanks & Regards,
Raghu Ram
EnterpriseDB: http://www.enterprisedb.com