I made a fulltext search on my database. The SQL query is "select * from product match(product_name) against ('Tree')". I got the results "Trunk of an Old Yew Tree,Tree Trunks with Ivy,Rocks with Oak Tree...".But when I change the search word "Tree" to "tree",I got no result.
Fulltext search function seems to be no case sensitive,so how do I fix this problem?