3 messages in com.mysql.lists.win32myisamchk removes words with national...| From | Sent On | Attachments |
|---|---|---|
| Lukas Zapletal | 03 Dec 2002 04:19 | |
| Jeff Williams | 04 Dec 2002 20:22 | |
| Ignatius Reilly | 05 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.
Synopsis: myisamchk removes words with nationals from fulltext index Submitter-Id: lzap Originator: Lukas Zapletal MySQL support: none Severity: non-critical Priority: medium Category: mysql utils Class: sw-bug Release: mysql-4.0.5 beta
Exectutable: mysqld-nt Environment: AMD Athlon 1600+, 512MB RAM System: WinXP Compiler: VC++ 6.0 Architecture: i
-- Lukas Zapletal lz...@root.cz




