Magento hebrew full text search

Proper using hebrew in Magento needs some tuning. I had a problem to find such phrases as: ‘??? ???’ or ‘???’. I have used MySQL 5.1.49. The minimum and maximum lengths of words to be indexed are defined by the ‘ft_min_word_len‘ and ‘ft_max_word_len‘ system variables.
SQL: ‘SHOW VARIABLES;’ I have found that ‘ft_min_word_len’ was 4.
I have changed it to 2 in ‘/etc/mysql/my.cnf‘ in [mysqld].

More information can be found here:
http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html
Then I reindexed the table with: ‘REPAIR TABLE catalogsearch_fulltext’.
More details:
http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

QUERY (native Magento query):

SELECT 7 AS `query_id`, `s`.`product_id`, MATCH (s.data_index) AGAINST (‘??? ???’ IN BOOLEAN MODE) AS `relevance`, s.data_index
FROM `catalogsearch_fulltext` AS `s`
WHERE (s.store_id = 2) AND (MATCH (s.data_index) AGAINST (‘??? ???’ IN BOOLEAN MODE));

RESULT:

| 7 | 2 | 0 | Name 1|???|Enabled|None|??? ???|??? ???|??? ???|33|1 |

| 7 | 1 | 0 | Name 2|Enabled|????|None|??? ???|??? ???|??? ???|25|1 |


4 Comments

  • Zineb |

    To show the left navigation bar, edit/app/design/frontend/default/default/layout/gallery.xmland nagche both instances ofpage/1column.phtmltopage/2columns-left.phtmlThis will show the left column, but depending on your site template, you may need to add your navigation block to the xml. This is because a default installation generally doesn’t have a left navigation, not at the root category level anyway. Minor note: the entire `gallery_index_index` xml block can be removed; it doesn’t do anything.As for the /admin/ redirect bug I wasn’t able to reproduce this. That’s certainly unusual, for now I would just recommend linking to /gallery/album/view/ directly, or if you have any more information that may be helpful in identifying what’s causing it, I can try to fix it.

  • how to find ppl on skype |

    Normally I don’t learn post on blogs, however I wish to say that this write-up very forced me to take a look at and do so! Your writing style has been amazed me. Thanks, quite great article.

  • click here |

    I was more than happy to find this website. I want to to thank you for ones time for this fantastic read!! I definitely loved every bit of it and I have you bookmarked to see new stuff on your blog.

  • website design |

    Magnificent post, very informative. I wonder why the opposite specialists of this sector do not understand this. You should continue your writing. I am sure, you have a great readers’ base already!|What’s Going down i am new to this, I stumbled upon this I’ve found It absolutely helpful and it has helped me out loads. I hope to give a contribution & aid different customers like its aided me. Good job.

So, what do you think ?