[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#795886: marked as done (Encoding problem in UDD? psql gives UTF-8 error)

Your message dated Fri, 20 Nov 2015 14:28:27 +0100
with message-id <20151120132827.GA4945@xanadu.blop.info>
and subject line Re: Bug#795886: Encoding problem in UDD? psql gives UTF-8 error
has caused the Debian Bug report #795886,
regarding Encoding problem in UDD? psql gives UTF-8 error
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)


-- 
795886: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=795886
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
Package: qa.debian.org
User: qa.debian.org@packages.debian.org
Usertags: udd

I get the following error when I use psql to query:

udd=> SELECT id, source FROM bugs WHERE id = 785359;
ERROR:  invalid byte sequence for encoding "UTF8": 0xa0

I looked up the bug and noticed
    Reported by: Bohumil Šimčík <limuhob@outlook.com>
but everything should be UTF-8, right?

(It's strange that I get the error when I only SELECT id and
source.)
-- 
Martin Michlmayr
Linux for HP Helion, Hewlett-Packard

--- End Message ---
--- Begin Message --- 
On 19/11/15 at 21:15 +0100, Lucas Nussbaum wrote:
> On 17/08/15 at 19:35 +0200, Martin Michlmayr wrote:
> > Package: qa.debian.org
> > User: qa.debian.org@packages.debian.org
> > Usertags: udd
> > 
> > I get the following error when I use psql to query:
> > 
> > udd=> SELECT id, source FROM bugs WHERE id = 785359;
> > ERROR:  invalid byte sequence for encoding "UTF8": 0xa0
> > 
> > I looked up the bug and noticed
> >     Reported by: Bohumil Šimčík <limuhob@outlook.com>
> > but everything should be UTF-8, right?
> > 
> > (It's strange that I get the error when I only SELECT id and
> > source.)
> 
> Hi,
> 
> the bugs importer was converting most fields to UTF8, but not the
> package names. Unfortunately, there are some package names in debbugs
> that are not UTF8 (due to non-breaking spaces, for example).
> 
> I've fixed it in the importer. The live data should be fixed over the
> next 24 hours. I'll check again tomorrow.
 
hi,

all source packages have been fixed.
"SELECT id, source, package from bugs" works fine now.

the same with archived_bugs isn't fixed yet, but should be over the next
couple of days, when all bugs will be refreshed.

So, closing this bug.

Lucas

--- End Message ---
Reply to: