<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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(at)mail(dot)gmail(dot)com"
type="cite"><br>
<br>
<div class="gmail_quote">On Sat, Apr 14, 2012 at 9:31 AM, 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>
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 set client_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>
<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>