Re: tsearch2 & unicode

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Michal Hlavac <hlavki(at)hlavki(dot)sk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tsearch2 & unicode
Date: 2005-09-06 17:58:35
Message-ID: Pine.GSO.4.63.0509062152590.14250@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This message is in MIME format. The first part should be readable text,
while the remaining parts are likely unreadable without MIME-aware tools.

---559023410-637165587-1126029515=:14250
Content-Type: TEXT/PLAIN; charset=koi8-r; format=flowed
Content-Transfer-Encoding: 8BIT

Michal,

tsearch2 doesn't supports UTF-8. It might works though.
full support of UTF-8 and other features are planned
http://www.sai.msu.su/~megera/oddmuse/index.cgi/todo

Oleg
On Tue, 6 Sep 2005, Michal Hlavac wrote:

> hello,
>
> I have suse 9.3 with installed postgresql 8.0.3 from rpm.
> All my databases are unicode with locale sk_SK.UTF-8.
> I installed slovak ispell dictionary and tsearch2 is working very well.
>
> m13=# SELECT lexize('sk_ispell','Ivana');
> lexize
> --------------
> {ivana,ivan}
> (1 row)
>
>
> On the other side I have FreeBSD also with postgresql 8.0.3 and with
> unicode database. I also installed slovak ispell dictionary and tsearch2
> is working very well.
> but result:
> hlk=# SELECT lexize('sk_ispell','Ivana');
> ERROR: Regex error in 'ia[tЪЪina$': brackets [] not balanced
>
> where is the problem??? thanks, miso
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---559023410-637165587-1126029515=:14250--

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michal Hlavac 2005-09-06 18:11:47 Re: tsearch2 & unicode
Previous Message Vlad 2005-09-06 17:45:47 "select ..... for update of ..." doesn't support full qualified table name?