MySQL Forums
Forum List  »  MyISAM

Re: FullText Search giving Case sensitive results , Big Problem!!
Posted by: Toomula Nanda kishore
Date: December 08, 2011 05:54AM

it is all about collation

please see

http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html


"By default, the search is performed in case-insensitive fashion. However, you can perform a case-sensitive full-text search by using a binary collation for the indexed columns. For example, a column that uses the latin1 character set of can be assigned a collation of latin1_bin to make it case sensitive for full-text searches"

Nanda kishore .T

Options: ReplyQuote




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.