On Mittwoch, 12. Dezember 2007, cnit wrote: > > Oops. Same old collation issue. I applied the fix given in [1]. I think > > some DB backup must have caused this. > > The best way to get rid of these problems (which initially gave me a > lots of headache) is to stop using precompiled RPM or windows > installer versions of mysql server, which use latin1 charset and > swedish collation by default. > > Instead, I configure mysql with the following options > ./configure\ > '--with-charset=utf8'\ > '--with-collation=utf8_unicode_ci'\ > > and compile it myself.
Well, not sure ... in general, SMW and MW have rather similar ways of creating tables, and normally they just come out having the same settings (it does not matter if they use Swedish collation, as long as they use the same). I believe that the observed problems stem from having a database where settings somehow changed between MW and SMW installation, so that SMW used other default collation settings than MW used when making its tables. I assume it should be possible to have a script that just changes the collation of all text-fields in all tables to whatever value some admin wants. > The cons - you have to be a root (have colocation or something like > that). > > Also, you may find an mysql access class of MW and patch it yourself > with > 'SET collation_connection = utf8_unicode_ci' > > MySQL is frustrating to don't use UTF8 by default. Note that the UTF8-DB-encoding option (referring to the one offered during install now) is considered experimental for MediaWiki. And choosing it currently is a sure way to get these problems in any case. So to all you users who read this message later: unless you are comfortable with compiling your own DB servers as well, please be careful with such settings ;-) The default settings should normally work. Markus -- Markus Krötzsch Institut AIFB, Universät Karlsruhe (TH), 76128 Karlsruhe phone +49 (0)721 608 7362 fax +49 (0)721 608 5998 [EMAIL PROTECTED] www http://korrekt.org
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
