"Hellekin O. Wolf" wrote:
>
> Hello,
>
> installing the create/stopword/stop.fr.txt data file into mysql produces an
> error on similar words with accents.
> For example 'la' and 'l�' look the same for mysql when it comes to indexing
> the primary key.
> It prevents accented words to be taken into account.
>
> I bet this problem arises in any languages using accents.
>
> Sorry, I can't think of a solution on the database level.
> Maybe some routine might get rid of accents when whecking the stopwords ?
>
> hellekin
You have to use MySQL with proper charset to avoid these letter muxing.
Another solution is to ignore duplicates.
mysql -f database < stop.fr.txt
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
