Re: Text search, ERROR: invalid byte sequence for encoding "UTF8": 0xe9640a - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: Text search, ERROR: invalid byte sequence for encoding "UTF8": 0xe9640a
Date
Msg-id Pine.LNX.4.64.0902031907150.4158@sn.sai.msu.ru
Whole thread Raw
In response to Text search, ERROR: invalid byte sequence for encoding "UTF8": 0xe9640a  (James Dooley <jamdooley@gmail.com>)
List pgsql-general
James,

you forgot to convert files to UTF8.
iconv -f ISO8859-1 -t utf8 en_GB.dic > en_gb.dict
iconv -f ISO8859-1 -t utf8 en_GB.aff > en_gb.affix

Oleg
On Tue, 3 Feb 2009, James Dooley wrote:

> I downloaded the hunspell en_GB from
>
> http://wiki.services.openoffice.org/wiki/Dictionaries#English_.28AU.2CCA.2CGB.2CNZ.2CUS.2CZA.29
>
> and when building the Ispell dictionary I got the following error
>
> ERROR:  invalid byte sequence for encoding "UTF8": 0xe9640a
> 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".
> CONTEXT:  line 220 of configuration file "C:/Program
> Files/PostgreSQL/8.3/share/tsearch_data/en_gb.dict"
>
> CREATE TEXT SEARCH DICTIONARY english_ispell (
>    TEMPLATE = ispell,
>    DictFile = en_GB,
>    AffFile = en_GB,
>    StopWords = english
> );
>

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

pgsql-general by date:

Previous
From: James Dooley
Date:
Subject: Re: Text search, ERROR: invalid byte sequence for encoding "UTF8": 0xe9640a
Next
From: rhubbell
Date:
Subject: Re: calculating elapsed times between timestamps