Thread:Help talk:Selecting pages/Case insensitive query possible?/reply (5)

I've managed to get case insensitive ask queries in MW 1.21.1, SMW 1.8.0.5, by setting the character set and collation, and changing 3 columns from varbinary to varchar.


 * 1) During the database step in the mediawiki installation, choose UTF8 as the database character set.  (If binary was chosen the DB needs to be recreated and pages migrated).  Note that issues have been noted by other users with UTF8 and some languages, so test this thoroughly if using a language containing special characters.
 * 2) Backup database using mysqldump
 * 3) Open MySQL Workbench as the root (or other authorised) user
 * 4) Run the following script:
 * 5. Case insensitive searching should now work

Note that you may get an error with the UPDATE statements if your preferences in MySQL Workbench are set with "Safe Update" on. This can be turned off by going to Edit>Preferences...>SQL Queries tab. Then uncheck "Safe Updates"... and reconnect to the DB.