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

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