pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rural Hunter <ruralhunter@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: invalid byte sequence for encoding "UTF8": 0xf481 - how could this happen?
Date: Sun, 15 Apr 2012 13:32:53 +0800
Message-ID: <4F8A5D85.4000808@gmail.com> (raw)
In-Reply-To: <CALnrrJSCuGpJTRx_Vg8efcs+o-t0=PABpcOz5AJ+jkZ=jTNq+g@mail.gmail.com>
References: <4F88DB40.9070609@gmail.com>
	<CALnrrJTPzsNvaFP_qHisMS=wwp2bkvK=gk_wPDzC-fdaXEkypA@mail.gmail.com>
	<4F88F684.3030405@gmail.com>
	<CALnrrJSCuGpJTRx_Vg8efcs+o-t0=PABpcOz5AJ+jkZ=jTNq+g@mail.gmail.com>

<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@mail.gmail.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@gmail.com">ruralhunter@gmail.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>



view thread (29+ messages)  latest in thread

Message-ID: <4F8A5D85.4000808@gmail.com>
Permalink:  ../4F8A5D85.4000808@gmail.com/
Also on:    postgresql.org/message-id/4F8A5D85.4000808@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ruralhunter@gmail.com
  Subject: Re: invalid byte sequence for encoding "UTF8": 0xf481 - how could this happen?
  In-Reply-To: <4F8A5D85.4000808@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox