MySQL Forums
Forum List  »  Full-Text Search

Re: Full-Text Search not work in new version!
Posted by: mahmud mofrad
Date: August 24, 2012 03:58AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
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.