It seems that ever since I upgraded MySQL to 4.1, PhpWiki's TitleSearch, FullTextSearch, and LikePages functions no longer work properly.
TitleSearch will return nothing, even for an exact string matching a given page (in fact, the pagename *is* linked in the search results header!).
LikePages and FullTextSearch no longer return anything for terms that should return results.
FuzzySearch continues to work fine, though.
Hmm.. brain tingle... could this be an ASCII->Unicode problem?
Whee!
ALTER TABLE page CHARACTER SET latin1 COLLATE latin1_general_ci;
fixed this problem.
For some reason, in MySQL 4.1, page.pagename is created with 'binary' collation.
Log in to post a comment.
It seems that ever since I upgraded MySQL to 4.1, PhpWiki's TitleSearch, FullTextSearch, and LikePages functions no longer work properly.
TitleSearch will return nothing, even for an exact string matching a given page (in fact, the pagename *is* linked in the search results header!).
LikePages and FullTextSearch no longer return anything for terms that should return results.
FuzzySearch continues to work fine, though.
Hmm.. brain tingle... could this be an ASCII->Unicode problem?
Whee!
ALTER TABLE page CHARACTER SET latin1 COLLATE latin1_general_ci;
fixed this problem.
For some reason, in MySQL 4.1, page.pagename is created with 'binary' collation.