3 messages in com.mysql.lists.win32myisamchk removes words with national...
FromSent OnAttachments
Lukas Zapletal03 Dec 2002 04:19 
Jeff Williams04 Dec 2002 20:22 
Ignatius Reilly05 Dec 2002 02:38 
Subject:myisamchk removes words with national characters from fulltext index
From:Lukas Zapletal (lz@root.cz)
Date:12/03/2002 04:19:34 AM
List:com.mysql.lists.win32

Description: ~~~~~~~~~~~~ Dears I have this table:

Create table documents ( id_document Int NOT NULL AUTO_INCREMENT, title Varchar(250) , document Longtext , Primary Key (id_document), FULLTEXT Index ix_documents_data (title, document) ) TYPE = MyISAM;

It has fulltext index. I properly created it in latin2 configured server, I filled it with latin2 data and 2MB fulltext index was created. Everything works fine.

So. I desided to ditribute my application. I compressed the table with myisampack and I run myisamchk -rq documents. The index size decreased to 1MB and when I want to find any word with national character (in latin2), it doesn`t work. Words without these characters works fine.

I found that the fulltext index size decreases while myisamchecking it. I have latin2 in my.ini in the windows directory, I also tried to run with --set-character-set=latin2. But with no change.

How-To-Repeat: ~~~~~~~~~~~~~~ Create the table, fill some data with national characters (e.g. download some czech article from the site http://www.root.cz), run myisamchk and try to find something. See the index size. It gets decreased because myisamchk doesn`t index words with nationales.

Exectutable: mysqld-nt Environment: AMD Athlon 1600+, 512MB RAM System: WinXP Compiler: VC++ 6.0 Architecture: i