<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
doesn't work either.<br>
<br>
db=# show client_encoding;<br>
client_encoding <br>
-----------------<br>
UTF8<br>
(1 row)<br>
<br>
db=# set client_encoding='LATIN1';<br>
SET<br>
db=# show client_encoding;<br>
client_encoding <br>
-----------------<br>
LATIN1<br>
(1 row)<br>
<br>
db=# select to_tsvector(content) from tmp_article;<br>
ERROR: invalid byte sequence for encoding "UTF8": 0xf481<br>
<br>
于 2012/4/14 10:15, raghu ram 写道:
<blockquote
cite="mid:CALnrrJTPzsNvaFP_qHisMS=wwp2bkvK=gk_wPDzC-fdaXEkypA(at)mail(dot)gmail(dot)com"
type="cite"><br>
<br>
<div class="gmail_quote">2012/4/14 Rural Hunter <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:ruralhunter(at)gmail(dot)com">ruralhunter(at)gmail(dot)com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
My db is in utf-8, I have a row in my table say tmp_article
and I wanted to generate ts_vector from the article content:<br>
select to_tsvector(content) from tmp_article;<br>
But I got this error:<br>
ERROR: invalid byte sequence for encoding "UTF8": 0xf481<br>
<br>
I am wondering how this could happen. I think if there was
invalid UTF8 bytes in the content, it shouldn't have been able
to inserted into the tmp_article table as I sometimes see
similar errors when inserting records to tmp_article. Am I
right?<span class="HOEnZb"><font color="#888888"><br>
<br>
</font></span></blockquote>
<div><br>
</div>
<div>
<p class="p1">This error can also happen if the <span
class="s1">byte</span> <span class="s1">sequence</span>
does not match the <span class="s1">encoding</span>
expected by the server, which is controlled by
"client_encoding".</p>
</div>
<div>Try to set client_encoding='LATIN1' </div>
<div><br>
</div>
<div>and then execute </div>
</div>
<div><br>
</div>
select to_tsvector(content) from tmp_article;<br clear="all">
<div><br>
</div>
-- <br>
<p>Thanks & Regards,</p>
<p>Raghu Ram</p>
<p>EnterpriseDB: <a moz-do-not-send="true"
href="http://www.enterprisedb.com/" target="_blank"><span>http://www.enterprisedb.com</span></a></p>
<br>
</blockquote>
<br>
</body>
</html>