The wiki I'm developing used to support case-insensitive Ask queries under some circumstances, but later stopped. I found a reference to something similar at <http://www.mediawiki.org/wiki/Extension_talk:Semantic_Drilldown> (specifically, Yaron Koren's reply to the Broken Combobox thread on June 15, 2010). It seems that the issue had to do with LIKE queries becoming case-sensitive rather than case-insensitive.
I've gone looking through the MySQL docs to deal with this, and seem to have come up with a solution: changing the default collations in smw_attributes and smw_atts2 from "latin1_binary" to "latin1" seems, at least in preliminary testing, to restore case-insensitive LIKE, which in turn seems to restore case-insensitive querying. Again, I've only done preliminary work with this. I'm not quite clear on the history of the SMW database schema, though, so I'm not really sure if this stands to cause errors elsewhere. Is there a reason SMW uses the binary latin1 concatenations now? Are there any well-known errors from previous versions that might regress in this kind of case? ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
