Re: Full-Text Search not work in new version!
Hi,
My data is inserted directly in the MySQL 5.5. (with PHP)
Other information is:
Generated by: phpMyAdmin 3.4.9 / MySQL 5.5.20
SQL query: SELECT title, HEX(title), LENGTH(title), CHAR_LENGTH(title) FROM products limit 1;
title | HEX(title) | LENGTH(title) | CHAR_LENGTH(title)
درب HDF مدل sd1 | C398C2AFC398C2B1C398C2A82048444620C399E280A6C398C2AFC399E2809E20736431 | 35 | 21
SQL query: SHOW VARIABLES LIKE 'ft%';
Variable_name | Value
ft_boolean_syntax | + -><()~*:""&|
ft_max_word_len | 84
ft_min_word_len | 4
ft_query_expansion_limit | 20
ft_stopword_file | (built-in)
Yes! VARIABLES is same as before.
Generated by: phpMyAdmin 3.4.9 / MySQL 5.5.20
SQL query: EXPLAIN SELECT ....
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra
1 | SIMPLE | p | fulltext | title | title | 0 | | 1 | Using where; Using filesort
1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | p.company_id | 1 | Using where
SQL query: SHOW VARIABLES LIKE 'collation%';
Variable_name | Value
collation_connection | utf8_general_ci
collation_database | utf8_persian_ci
collation_server | latin1_swedish_ci
SQL query: SHOW SESSION VARIABLES LIKE 'character_set%';
Variable_name | Value
character_set_client | utf8
character_set_connection | utf8
character_set_database | utf8
character_set_filesystem | binary
character_set_results | utf8
character_set_server | latin1
character_set_system | utf8
Thanks.
Subject
Views
Written By
Posted
3991
August 20, 2012 05:56AM
2301
August 22, 2012 10:56PM
2144
August 23, 2012 12:28AM
2325
August 23, 2012 07:52PM
Re: Full-Text Search not work in new version!
2300
August 24, 2012 03:58AM
3226
August 25, 2012 01:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.