The BLOBs are fine, it's just the VARCHARs, `ar_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', How can one convert these back to UTF-8 with a script, outside of mysql, just for occasional viewing of the SQL dumps outside of the wiki. Yes, my wiki works fine. OK, I'll study http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_latin1_…

On Fri, Mar 6, 2009 at 3:54 PM, Daniel Kinzler <daniel(a)brightbyte.de> wrote: Best way is to use VARBINARY or BINARY

note to self: look into the code that order text (collation) in mediawiki, has to be fun one :-) -- -- ℱin del ℳensaje.

On Wed, Mar 11, 2009 at 6:14 AM, Daniel Kinzler <daniel(a)brightbyte.de> wrote: And until we upgrade to that version. MySQL 4 doesn't have *any* Unicode support -- or any character encoding support, in fact. Every is binary. But we don't have to wait on MySQL. We would just have to store a Unicode sortkey in cl_sortkey instead of the actual Unicode characters. This would require an implementation of a Unicode sorting algorithm in MediaWiki. It could be language-specific or whatever you want.

Aryeh Gregor schrieb: right :) Yes, i thought about that a bit too. One problem would be that you can't use that to make pretty sections on the category page. But that would be solvable using an extra column, I suppose. Or by some kind of extra special magic mapping. -- daniel

Hoi, If you are interested in collation, you may want to look into the CLDR, it is where the collations are registered per language. There is no such thing as an universally correct sorting algorithm.. NB the CLDR is a UNICODE project. Thanks, GerardM 2009/3/11 Aryeh Gregor <Simetrical+wikilist@gmail.com<Simetrical%2Bwikilist@gmail.com > On Wed, Mar 11, 2009 at 6:14 AM, Daniel Kinzler &lt;daniel(a)brightbyte.de> wrote: > > There is none. Sorting is done by the database. That is to say, in the > default > > "comnpatibility" mode, binary "collation" is used - that is, byte-by-byte > > comparison of UTF-8 encoded data. Which sucks. But we are stuck with it > until > > MySQL gets proper Unicode support. > And until we upgrade to that version. MySQL 4 doesn't have *any* > Unicode support -- or any character encoding support, in fact. Every > is binary. > But we don't have to wait on MySQL. We would just have to store a > Unicode sortkey in cl_sortkey instead of the actual Unicode > characters. This would require an implementation of a Unicode sorting > algorithm in MediaWiki. It could be language-specific or whatever you > want. > _______________________________________________ > Wikitech-l mailing list > Wikitech-l(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Aran wrote: It's not a backwards compatibility mode. It's just a different configuration. In fact, Wikimedia servers are working with mysql 4.0! :)