User talk:JohanTheGhost

just thought i would tell you that your wikipiedia page follows to a page that doesn't exist


 * Thanks, fixed it. JohanTheGhost 14:10, 29 June 2007 (UTC)

RigorousSearch
I have a remark about your RigorousSearch extension (which is really useful for me). My mediawiki table "text" is from type InnoDB. The "old_text" field is stored as MEDIUMBLOB. But BLOBs are case-sensitive. So, I have to enter the search string with correct lower/upper case, which is - for me - not optimal. "Mediwiki" search string only finds "Mediawiki" but not "mediawiki".

I have changed the code by adding a CAST funtion in order to search case-insensitive: $queryTxt = "SELECT old_text FROM ". $db->tableName('text'). " WHERE old_id = ". $text_id. " AND CAST(old_text as CHAR) LIKE '%". $pattern. "%'";

Maybe it's worth to add to the "official" extension. 09:27, 7 February 2008 (UTC)