Thread: postgres 8.3 rc-1 ispell installation problem
hi folks i've tried to install ispell for CREATE TEXT SEARCH DICTIONARY spanish_ispell ( TEMPLATE = ispell, DictFile = spanish, AffFile = spanish, StopWords = spanish ); sentence, but, one error ocurrs ERROR: syntax error at line 432 of affix file "/usr/local/pgsql/share/tsearch_data/spanish.affix" the offending line is flag *J: # isimo E > -E, 'ISIMO # grand'isimo <-- here 432 E > -E, 'ISIMOS # grande grand'isimos E > -E, 'ISIMA # grande grand'isima E > -E, 'ISIMAS # grande grand'isimas O > -O, 'ISIMO # tonto tont'isimo O > -O, 'ISIMA # tonto tont'isima i think 'I.. word is not correct for ispell, this should be one Í letter but nothing seems to work .. I've tried select convert( 'ÍSIMO', 'SQL_ASCII', 'UTF8') , but don't work any clue? best regards sorry for my english :) Tarjeta de crédito Yahoo! de Banco Supervielle. Solicitá tu nueva Tarjeta de crédito. De tu PC directo a tu casa. www.tuprimeratarjeta.com.ar
> flag *J: # isimo > E > -E, 'ISIMO # grand'isimo <-- here 432 > E > -E, 'ISIMOS # grande grand'isimos > E > -E, 'ISIMA # grande grand'isima > E > -E, 'ISIMAS # grande grand'isimas > O > -O, 'ISIMO # tonto tont'isimo > O > -O, 'ISIMA # tonto tont'isima > Current implementation doesn't accept any character in ending except alpha ones. > i think 'I.. word is not correct for ispell, > this should be one Í letter That's right, but you should convert dictionary and affix file in UTF8 encoding. -- Teodor Sigaev E-mail: teodor@sigaev.ru WWW: http://www.sigaev.ru/
Thanks Teodor for quick response,and your work > That's right, but you should convert dictionary and > affix file in UTF8 encoding. how to i can do it? best regards MDC Yahoo! Encuentros. Ahora encontrar pareja es mucho más fácil, probá el nuevo Yahoo! Encuentros http://yahoo.cupidovirtual.com/servlet/NewRegistration
Teodor i've tried with openoffice.org but whitout success, :) ERROR: invalid byte sequence for encoding "UTF8": 0xe16261 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, i've tried too with convmv -f iso-8859-1 --notest -t utf-8 es_ES.dic whitout success too. my database encoding is LATIN1 i missing some thing ? best regards mdc > > flag *J: # isimo > > E > -E, 'ISIMO # grand'isimo <-- here > 432 > > E > -E, 'ISIMOS # grande grand'isimos > > E > -E, 'ISIMA # grande grand'isima > > E > -E, 'ISIMAS # grande grand'isimas > > O > -O, 'ISIMO # tonto tont'isimo > > O > -O, 'ISIMA # tonto tont'isima > > > Current implementation doesn't accept any character > in ending except alpha ones. > > > i think 'I.. word is not correct for ispell, > > this should be one Í letter > That's right, but you should convert dictionary and > affix file in UTF8 encoding. > > > -- > Teodor Sigaev > E-mail: teodor@sigaev.ru > > WWW: http://www.sigaev.ru/ > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend > Yahoo! Encuentros. Ahora encontrar pareja es mucho más fácil, probá el nuevo Yahoo! Encuentros http://yahoo.cupidovirtual.com/servlet/NewRegistration
marcelo Cortez escribió: > i've tried too with > convmv -f iso-8859-1 --notest -t utf-8 es_ES.dic > whitout success too. convmv only recodes the name of the file -- the content is not affected. To recode the file content you need iconv. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
Thanks Alvaro iconv -f iso-8859-1 -t utf-8 es_ES.dict > es.dict works!! --- Alvaro Herrera <alvherre@commandprompt.com> escribió: > marcelo Cortez escribió: > > > i've tried too with > > convmv -f iso-8859-1 --notest -t utf-8 > es_ES.dic > > whitout success too. > > convmv only recodes the name of the file -- the > content is not affected. > To recode the file content you need iconv. > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to > majordomo@postgresql.org so that your > message can get through to the mailing list > cleanly > Tarjeta de crédito Yahoo! de Banco Supervielle. Solicitá tu nueva Tarjeta de crédito. De tu PC directo a tu casa. www.tuprimeratarjeta.com.ar