https://bugzilla.wikimedia.org/show_bug.cgi?id=30705
--- Comment #12 from Markus Krötzsch <[email protected]> 2012-07-13 08:19:33 UTC --- I believe that the cause of this problem is that a temporary table is created to compute the results of this particular special page. The problem then occurs due to incompatible character encoding settings between your existing tables and this new table. The way in which SMW creates the temporary table on MySQL is: CREATE TEMPORARY TABLE tablename( title VARCHAR(255) ) ENGINE=MEMORY The encoding used in this table therefore defaults to the global settings. It is possible that these are not the same as for the other tables. It should be possible to fix the problem by changing all table encodings to be the same, and making sure that this is also the encoding used as a default. The deeper architectural problem is that MediaWiki uses the global variable $wgDBTableOptions for defining additional options, including specific charsets (I think). However, these global options usually include the ENGINE setting. So we cannot use them for temporary tables. So if somebody changes $wgDBTableOptions to use a non-default charset, SMW will take this into account only for its normal tables. Do you have a custom setting for $wgDBTableOptions? In the long run, we should also find a more efficient way to compute the results on this special page. The current solution does not scale to bigger wikis. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
