Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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?

pgsql-admin by date

Next:From: Tom LaneDate: 2012-01-04 16:33:20
Subject: Re: List archives dead?
Previous:From: Dick VisserDate: 2012-01-04 13:06:14
Subject: List archives dead?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group