Re: Text Search Configuration Problem

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Kevin Reynolds <kreynolds98092(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Text Search Configuration Problem
Date: 2008-04-06 04:11:36
Message-ID: Pine.LNX.4.64.0804060806590.21547@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin,

it looks like you use UTF-8, so the problem in .aff file, which contains
cyrillic comments :) I converted files into UTF-8 encoding using iconv.

Oleg

On Thu, 3 Apr 2008, Kevin Reynolds wrote:

> I'm using Postgresql version 8.3.1 on CentOS 5 and am following the steps in section 12.7 of the documentation for creating a custom text search configuration.
>
> When I get to the step that says:
>
> CREATE TEXT SEARCH DICTIONARY english_ispell (
> TEMPLATE = ispell,
> DictFile = english,
> AffFile = english,
> StopWords = english
> );
>
> I get the following error:
>
> ERROR: invalid byte sequence for encoding "UTF8": 0xe0c020
> HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
>
> I'm using the english ispell files from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
>
> Does anyone know how to solve this?
>
>
> ---------------------------------
> You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-04-06 08:07:24 Re: pl/pgsql RECORD data type, how to access to the values
Previous Message Tom Lane 2008-04-06 03:52:51 Re: Limiting postgresql resources