neteagle

[!--quoteo(post=386284:date=Jun 21 2006, 12:08 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jun 21 2006, 12:08 AM) [snapback]386284[/snapback][/div][div class=\'quotemain\'][!--quotec--] I didn't mean reset -- I said that you can change it on-the-fly with the collate attribute to "utf8_general_ci"... see [a href=\"http://dev.mysql.com/doc/refman/5.0/en/charset-collate.html\" target=\"_blank\"]here[/a]. Sorry about the mix-up. [/quote] Thanks fenway, I got it

[!--quoteo(post=386000:date=Jun 20 2006, 08:26 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jun 20 2006, 08:26 AM) [snapback]386000[/snapback][/div][div class=\'quotemain\'][!--quotec--] I'm fairly sure that you can reset the collation use the COLLATE attribute after the field, but I don't remember the syntax specifically; I'm sure it's in the refman pages. [/quote] Thanks fenway, I know it can reset the collation, I just want to know how to make the full_text search function case-insensitive with UTF8.

My collation is UTF8-bin. I want the search to be case-insensitive. How can I do that?

I want to do a full_text search query. SELECT * FROM `product` WHERE MATCH (`product_name`) AGAINST ('Flower') With this query, I got some results,but when I changed 'Flower' to 'flower', I got nothing. It seems full_text search function case sensitive. How can I fix it?