https://bugzilla.wikimedia.org/show_bug.cgi?id=19406
--- Comment #9 from Patrick <[email protected]> 2009-07-10 11:27:39 UTC --- (In reply to comment #8) > But unfortunately, this new > patch doesn't work for me, for properties of type "page", since page titles > are > stored in the database with underscores instead of spaces - any space in the > search string leads to no results. Do page titles have spaces in the > "VARBINARY" representation? No, they also have underscores - I just didn't think of that, and didn't test with properties of type "page". Now the space-problem is fixed for type "string" properties, but it's broken for type "page" properties. > In any case, a true solution has to handle both, in > one way or another - maybe just through an "if" statement. Yes, either with an if-statement, or doing a MySQL-String-Replace (http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace) in order to convert the underscores to spaces. Selecting the smw_sortkey column instead of the smw_title column would probably also work - since the only difference between those two seems to be that smw_sortkey values have spaces instead of underscores. Which solution would you prefer? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
