Bug#795886: Encoding problem in UDD? psql gives UTF-8 error

[Lucas Nussbaum <lucas@debian.org>]

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.

Lucas