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

Re: invalid byte sequence for encoding "UTF8": 0xf481 - how could this happen?

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: invalid byte sequence for encoding "UTF8": 0xf481 - how could this happen?
Date: 2012-04-15 05:32:53
Message-ID: 4F8A5D85.4000808@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
<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:&nbsp; invalid byte sequence for encoding "UTF8": 0xf481<br>
    <br>
    <br>
    &#20110; 2012/4/15 1:38, raghu ram &#20889;&#36947;:
    <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">&lt;<a moz-do-not-send="true"
            href="mailto:ruralhunter(at)gmail(dot)com">ruralhunter(at)gmail(dot)com</a>&gt;</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>
            &nbsp;client_encoding <br>
            -----------------<br>
            &nbsp;UTF8<br>
            (1 row)<br>
            <br>
            db=# set client_encoding='LATIN1';<br>
            SET<br>
            db=# show client_encoding;<br>
            &nbsp;client_encoding <br>
            -----------------<br>
            &nbsp;LATIN1<br>
            (1 row)<br>
            <br>
            db=# select to_tsvector(content) from tmp_article;
            <div class="im"><br>
              ERROR:&nbsp; 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'&nbsp;</div>
              <div><br>
              </div>
              <div>and then execute&nbsp;</div>
            </div>
            <div><br>
            </div>
            select to_tsvector(content) from tmp_article;<br clear="all">
          </blockquote>
        </div>
        <div><br>
        </div>
      </div>
      -- <br>
      <p>Thanks &amp; 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>


Attachment: unknown_filename
Description: text/html (2.4 KB)

In response to

pgsql-admin by date

Next:From: Chris ErnstDate: 2012-04-16 00:41:05
Subject: Recreate primary key without dropping foreign keys?
Previous:From: Tom LaneDate: 2012-04-15 00:01:02
Subject: Re: Trouble w/ COPY command

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