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@xxxxxxxxxx, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org