still doesn't work.<br /> db=# set client_encoding='SQL_ASCII' ;<br /> SET<br /> db=# select to_tsvector(content) from
tmp_article;<br/> ERROR: invalid byte sequence for encoding "UTF8": 0xf481<br /><br /><br /> 于 2012/4/15 1:38, raghu
ram写道: <blockquote cite="mid:CALnrrJSCuGpJTRx_Vg8efcs+o-t0=PABpcOz5AJ+jkZ=jTNq+g@mail.gmail.com" type="cite"><br /><br
/><divclass="gmail_quote">On Sat, Apr 14, 2012 at 9:31 AM, Rural Hunter <span dir="ltr"><<a
href="mailto:ruralhunter@gmail.com"moz-do-not-send="true">ruralhunter@gmail.com</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div 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; <div class="im"><br /> ERROR: invalid byte sequence for encoding "UTF8":
0xf481<br/></div></div></blockquote><div><br /></div><div><blockquote type="cite"><div class="gmail_quote"><div>Try to
setclient_encoding='SQL_ASCII' </div><div><br /></div><div>and then execute </div></div><div><br /></div> select
to_tsvector(content)from tmp_article;<br clear="all" /></blockquote></div><div><br /></div></div> -- <br /><p>Thanks
&Regards,<p>Raghu Ram<p>EnterpriseDB: <a href="http://www.enterprisedb.com/" moz-do-not-send="true"
target="_blank"><span>http://www.enterprisedb.com</span></a><br/></blockquote><br />