[RESOLVED] Fulltext Search (case insensitive)

[2005]

Hello,

Is there any method how to force fulltext search to return all records which contain "word" or "Word" or "wOrD" if I search for "word"?

I can not use "LIKE '%$word%'" method because DB is too big and searching takes very long time.

Thanks.

[dagon]

specify a Collation that ends in ci (case insensitive)

[Roger_Ramjet]

Well by default FTS is case-insensitive

"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."