Re: BUG #10589: hungarian.stop file spelling error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: "zsoros(at)gmail(dot)com" <zsoros(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #10589: hungarian.stop file spelling error
Date: 2014-06-10 20:22:00
Message-ID: 4576.1402431720@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Kevin Grittner <kgrittn(at)ymail(dot)com> writes:
> "zsoros(at)gmail(dot)com" <zsoros(at)gmail(dot)com> wrote:
>> I'm sorry, I can't give you the utf8 byte sequence for ''

> A quick copy/paste from your email into psql (using UTF-8 encoding)
> shows:
> [ it's U+0151 ]

I believe that the way we got this file in the first place was to
scrape it from
http://snowball.tartarus.org/algorithms/hungarian/stop.txt
since it's not in the Snowball distribution. It looks to me like the
webserver delivers that page in LATIN1 (ISO-8859-1) encoding, which would
go far towards explaining the encoding problem, since U+0151 isn't
representable in LATIN1. So now I'm wondering what other similar mistakes
there may be in the non-LATIN1 languages.

I have an inquiry in to the upstream Snowball list asking if there's a
safer way to obtain copies of their stopword files.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G Johnston 2014-06-10 20:36:00 Re: BUG #10591: setting newly added columns to null is slow
Previous Message Kevin Grittner 2014-06-10 20:15:47 Re: BUG #10591: setting newly added columns to null is slow