pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ben K. <bkim@coe.tamu.edu>
To: pgsql-admin@postgresql.org
Subject: encoding question
Date: Mon, 20 Mar 2006 16:56:57 -0600 (CST)
Message-ID: <Pine.GSO.4.64.0603201643250.21796@coe.tamu.edu> (raw)


Hi,

My main server is on Solaris (LANG=C), postgresql 8.1.0, with encoding 
SQL_ASCII.

I'm trying to set up a backup server on linux (LANG=en_US.UTF-8), with 
encoding UTF8.

I thought UTF8 was safe if all I have is ascii, since there was a relevant 
discussion in this list a short while ago, but I'm getting this error, for 
a few records (out of tens of thousands in that database).

===============
ERROR:  invalid UTF-8 byte sequence detected near byte 0x85
CONTEXT:  COPY tblcoursesinfo, line 30, column title: "Seminar in<85> 
..."
===============

The dump was created by 8.1.0's pg_dump with no options.

That line in the dump has the following contents.

Text:

n<85>       Knowledg

Binary:

02e2100: 6e85 2020 2020 2020 2020 2020 2020 2020  n.
02e2110: 2020 2020 2020 2020 2020 2020 2020 2020
02e2120: 2020 2020 2020 2020 2020 2020 2020 2020
02e2130: 2020 2020 2020 2020 2020 2020 2020 2020
02e2140: 2020 2020 2020 2020 2020 2020 2020 2020
02e2150: 2020 2020 2020 2020 2020 2020 2020 2020
02e2160: 2020 2020 2020 2020 2020 2020 2020 2020
02e2170: 2020 2020 2020 2009 4b6e 6f77 6c65 6467         .Knowledg

Where could this be coming from? Would appreciate help.


Regards,

Ben K.
Developer
http://benix.tamu.edu



view thread (10+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0603201643250.21796@coe.tamu.edu>
Permalink:  ../Pine.GSO.4.64.0603201643250.21796@coe.tamu.edu/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0603201643250.21796@coe.tamu.edu

 · 

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: bkim@coe.tamu.edu
  Subject: Re: encoding question
  In-Reply-To: <Pine.GSO.4.64.0603201643250.21796@coe.tamu.edu>

* 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