https://bugzilla.wikimedia.org/show_bug.cgi?id=19406
--- Comment #4 from Patrick <[email protected]> 2009-06-26 21:21:42 UTC --- (In reply to comment #3) > It appears that that page_title column used to be of type varbinary, but was > then switched to varchar at least four years ago (version 1.5) - you must be > using a very old wiki that's been upgraded along the way. What is your source for this information? Both Wikis I'm having this problem on are recent installations (started with 1.11.0 or later). I'm quite sure you can still get this with current Wiki installations - I think it's even the default. Have a look at the MediaWiki installer (config/index.php), at section Database character set: "Select one: [X] MySQL 4.1/5.0 binary [ ] MySQL 4.1/5.0 UTF-8 [ ] MySQL 4.0 backwards-compatible UTF-8 [...] In binary mode, MediaWiki stores UTF-8 text to the database in binary fields. This is more efficient than MySQL's UTF-8 mode, and allows you to use the full range of Unicode characters. In UTF-8 mode, MySQL will know what character set your data is in, and can present and convert it appropriately, but it won't let you store characters above the Basic Multilingual Plane. " MySQL 4.1/5.0 binary made more sense for me when I installed both Wikis (and it was set from the beginning, thus I regard it as default setting), and I guess that's where the VARBINARY comes from. -- 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
