Posts tagged with: MySQL

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].

Continue Reading