invalid byte sequence for encoding "UTF8": 0xf480

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: invalid byte sequence for encoding "UTF8": 0xf480
Date: 2012-01-04 14:33:00
Message-ID: 4F04631C.7040007@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

My db is in UTF-8 encoding. When I tried to generate gist index for some
rows I got the strange error:
select to_tsvector('chinesecfg',content) from article where
article_id=23834922;
ERROR: invalid byte sequence for encoding "UTF8": 0xf480
However, "select content from article where article_id=23834922" works
just fine and shows good content. Why the to_tsvector reported invalid
byte sequence since the 'content' already exists in db as UTF-8?

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2012-01-04 16:33:20 Re: List archives dead?
Previous Message Dick Visser 2012-01-04 13:06:14 List archives dead?